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
Abhishek AS 3Abhishek AS 3 

Validation rule on Status Picklist field based on Prior Value

I have a requirement on Status field. If previous value of status field  is "Story Definition" the value we can update must be only "Ready for DEv" or "Dev in Progress" if any other value is selected it must throw an error.
SwethaSwetha (Salesforce Developers) 
hi Abhishek,

Try below validation rule
  
AND(
TEXT(PRIORVALUE(Status)) = 'Story Definition',
NOT(ISPICKVAL(Status, 'Ready for DEv')),
NOT(ISPICKVAL(Status, 'Dev in Progress'))
)

If this information helps, please mark the answer as best. Thank you