Why does the If return number contain text?
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?
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.