Formula for Salesforce process builder when change from one picklist value to another value

AND(
OR(
TEXT([Case].Status) = “InProgress”,
TEXT([Case].Status) = “Working”
),
TEXT(PRIORVALUE([Case].Status)) = “Closed”
)

 

Use the Custom Lable in Process builder:

$Label.CUSTOMLABELNAME

Example 1:

OR(
  AND( ISPICKVAL([Opportunity].StageName, "Prospecting"),
       ISBLANK([Opportunity].NextStep) ),
  AND (ISPICKVAL([Opportunity].StageName, "Prospecting"),
   ISCHANGED([Opportunity].StageName),
  NOT(ISBLANK([Opportunity].NextStep)),
  NOT(ISCHANGED([Opportunity].NextStep)) ) )

Example 2:
AND(
      ISCHANGED([Object].Picklist__c),
      TEXT(PRIORVALUE([Object].Picklist__c)) = "Old value",
      TEXT[Object].(Picklist__c) = "New value"
)

Written by 

Salesforce MVP | Lightning Champion | 17x Salesforce Certified | Application Architect | 7x Trailhead Ranger | Techforce Services | Australia

Leave a Reply

Your email address will not be published. Required fields are marked *

*