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