I need advice in writing Contains function while using the Formula field.

CONTAINS("HP:H-P:NA.Co", Company) 

function should return true only if it matches the exact substring H-P or NA.Co in this case. Please let me know if any other in-built functionality can be used in place of Contains to match the company names


The expression which you have written will only evaluate to true if values will exactly match with Company name. According to your requirement you should try this:

CONTAINS(Compoany, "HP") || CONTAINS(Compoany, "H-P") || CONTAINS(Compoany, "NA.Co")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.