function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SDSFuserSDSFuser 

Contains Formula Error

Code:
IF( CONTAINS("SALESFORCE,MICROSOFT,AT&T", Upper(Company) ) , "XXX", "0")

This formula  returns True or XXX if the compnay name is soft or sales or les.  What is the proper delimter to be using for the the compnay name field.

I want it to return true or XXX if the company name contains....Salesforce or Microsoft or AT&T

Thank you for your help
JakesterJakester
Do you want it to return True or do you want it to return "XXX"? It can't do both. You also had the parameters reversed for Contains(). The way you have it constructed it will return "XXX", but you need to break the 3 phrases into different OR statements. Start simple and see if you can get one of them to work - something like
Code:
IF( CONTAINS(Upper(Company),"SALESFORCE") , "XXX", "0")

 If that works, then you can add OR() statements to capture your other phrases.