Apex Code Development You need to sign in to do that
Don't have an account?
Formula to compare value of 1 field against 3 possible values
I need to create a formula for a workflow rule that will compare value of one field against 3 possible values in another field:
AND (
(Position_Service_Level__c = "Self-Service"),
CASE(ts2__Project__c, "Untitled", true, "Creation", true, "Diffusion", true, false)
)
Basically for the first field the value will always be Self Service, but for the 2nd field it could be any one of the 3 possible values.
Hi
try this:-
IF(AND (
(Position_Service_Level__c = "Self-Service"),
OR(ts2__Project__c= "Untitled",ts2__Project__c= "Creation", ts2__Project__c= "Diffusion")
),true,false)
Thank you for your help. For some reason that isn't working and I'm not sure why. It looks like I made a mistake and the field is actually
project__c - text formula field . . . So I modified it but it is still not activating the workflow to send the email alert . . .
AND (
(Position_Service_Level__c = "Self-Service"),
OR(tproject__c= "Untitled",project__c= "Creation", project__c= "Diffusion")
)
I will keep trying.