Why does the If return number contain text?

130    Asked by DanPeters in Salesforce , Asked on Aug 30, 2023

 I want to get 1 if a text field has text that contains the formula salesforce. If there is no text, then I want to get 0. Even though I am getting the result I want by using EQUALS, I want to get the same result using CONTAINS. Can I get suggestions regarding this? 

Answered by David Edmunds

You can use both IF and OR like the code below: If you use NY, New York, and NewYork, the IF logic will work on an OR basis. If the mentioned city has any one of the three texts, it will show true and return 1. Otherwise, you will get 0.

Your Answer


Parent Categories