NOT(CONTAINS(Company_Office__c, Owner_Office__c))
Which is great but I need to add an exception that says except when either the Company_Office__c or the Owner_Office__c contains the word "Global"
Ideas?
답변 1개
Hi Cory, Please try the below
AND(
NOT(CONTAINS(Company_Office__c, "Global")),
NOT(CONTAINS(Owner_Office__c, "Global")),
NOT(CONTAINS(Company_Office__c, Owner_Office__c))
)
