All,
I am under the impression that the below is case sensitive, which seems absurd in mho. Is that the case?
Is there a better way to build the below so it is not case sensitive?
IF(
AND(
OR(
CONTAINS(Title,"CEO"),
CONTAINS(Title,"CFO"),
CONTAINS(Title,"CISO"),
CONTAINS(Title,"CTO"),
CONTAINS(Title,"CIO"),
CONTAINS(Title,"CMO"),
CONTAINS(Title,"Chief"),
CONTAINS(Title,"Chairman")),
NOT(CONTAINS(Title,"Assistant")),
NOT(CONTAINS(Title,"Retired"))),"CxO",
IFAND(
OR(
CONTAINS(Title,"President"),
CONTAINS(Title,"VP"),
CONTAINS(Title,"Pres.")),
NOT(CONTAINS(Title,"Assistant")),
NOT(CONTAINS(Title,"Retired"))),"VP/SVP",
IF(
AND(
OR(
CONTAINS(Title,"Director"),
CONTAINS(Title,"Dir"),
CONTAINS(Title,"Head")),
NOT(CONTAINS(Title,"Assistant")),
NOT(CONTAINS(Title,"Retired"))),"Director",
IF(
AND(
OR(
CONTAINS(Title,"Manager"),
CONTAINS(Title,"Mgr")),
NOT(CONTAINS(Title,"Assistant")),
NOT(CONTAINS(Title,"Retired"))),"Manager",
"Individual"
))))
Hi,
Indeed, CONTAINS is case-sensitive, it says it here:
https://help.salesforce.com/s/articleView?id=sf.customize_functions_a_h.htm&type=5
You could go with:IF( AND( OR( CONTAINS(UPPER(TITLE),"CEO"), CONTAINS(UPPER(TITLE),"CFO"), CONTAINS(UPPER(TITLE),"CISO"), CONTAINS(UPPER(TITLE),"CTO"), CONTAINS(UPPER(TITLE),"CIO"), CONTAINS(UPPER(TITLE),"CMO"), CONTAINS(UPPER(TITLE),"CHIEF"), CONTAINS(UPPER(TITLE),"CHAIRMAN")), NOT(CONTAINS(UPPER(TITLE),"ASSISTANT")), NOT(CONTAINS(UPPER(TITLE),"RETIRED"))),"CxO",
