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
impalacrazy69impalacrazy69 

Contains not working will only show on blank value

So i am looking to compare a picklist value to a name field where i take the value of the picklist and see if the name field contains that value. The formula works but however it only returns "match" when the name field is blank which is incorrect. Does anyone see what i am doing wrong.

IF(ISPICKVAL( Site__r.Support_Package__c , "Support") && CONTAINS("Support", Product__r.Name), "Match",
IF(ISPICKVAL( Site__r.Support_Package__c , "Enhanced") && CONTAINS("Enhanced", Product__r.Name), "Match",
IF(ISPICKVAL( Site__r.Support_Package__c , "Premium") && CONTAINS("Premium", Product__r.Name), "Match", "Different")))

Thanks.....
New_DeveloperNew_Developer
I think its other way. The field name should come first and the compare text should follw that. Try this
IF(ISPICKVAL( Site__r.Support_Package__c , "Support") && CONTAINS( Product__r.Name,"Support"), "Match",