function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Debbie DockeryDebbie Dockery 

PriorValue or IsPicklist Formula

I need a workflow to update “Previous Fit Call Date” field when “Fit Call Date” is changed AND, the priorvalue for  “Disposition” picklist field value was either “Attempting to Schedule Stage 1 Meeting” OR “Stage 1 Meeting Scheduled”.
Here's What I have but it's not working.

AND(
ISCHANGED(FIT_Call_Date__c),
PRIORVALUE(MI_Disposition__c) = "Attempting to Schedule Stage 1 Meeting",
PRIORVALUE(MI_Disposition__c) = "Stage 1 Meeting Scheduled"
)
VinayVinay (Salesforce Developers) 
Try below
  
AND(
ISCHANGED(FIT_Call_Date__c),
OR(
PRIORVALUE(MI_Disposition__c) = "Attempting to Schedule Stage 1 Meeting",
PRIORVALUE(MI_Disposition__c) = "Stage 1 Meeting Scheduled"
)
)

Thanks,