If Salesrep__c EQUALS "12" or "1" or "E43" or "90" then "Label1"
If Salesrep__c EQUALS "13" or "2" or "K22" or "98" then "Label2"
and so on
We currently have this in place but we need to specify more than one possible value for each label and the value could be '1' or '12' so we need to move away from "CONTAINS". Currently there are 5 labels and each label could have about 30 values.
IF(CONTAINS(Salesrep__c,"12"),"Label1",
IF(CONTAINS(Salesrep__c,"14"),"Label2",
IF(CONTAINS(Salesrep__c,"16"),"Label3",
IF(CONTAINS(Salesrep__c,"18"),"Label4","Other"))))
4 respuestas
Hi,
Am afraid we cannot use case function like that.
Can you share your formula, I might be able to help you reduce the formula length?
