function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
northcountrygalnorthcountrygal 

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.

@anilbathula@@anilbathula@

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)

northcountrygalnorthcountrygal

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.