Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Conditional Column using IF / AND / ELSE returning "FALSE"

I am trying to create a custom column that says

 

= if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then [Vendors Name] = "Jongo Plc" else [Vendors Name]

 

I am returning a "FALSE" result instead of Jongo Plc where it meets the condition for Jingo Inc + Jango Adams

 

What i need is the logic: if column 1 has Jingo Inc and column 2 has Jango Adams return Jongo Plc, else show the vendor in the original column. Please help out.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous,

    Try this in your custom column:

    = if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then "Jongo Plc" else [Vendors Name]

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    Try this in your custom column:

    = if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then "Jongo Plc" else [Vendors Name]
    • Anonymous's avatar
      Anonymous
      Not applicable

      Worked like a charm. Thank you!!