Forum Discussion
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" re...
Anonymous,
Try this in your custom column:
= if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then "Jongo Plc" else [Vendors Name]
Anonymous,
Try this in your custom column:
= if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then "Jongo Plc" else [Vendors Name]Worked like a charm. Thank you!!