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
Mark Goh 1Mark Goh 1 

Validation rule not to go back on a status (locked)

I have date stamps for different status I have set, the logic is check if date stamp exist for that particular status, if it does you can’t change back to a previous value. I can't figure out a way to do it. 
Maharajan CMaharajan C
Hi Mark,

Try the below Validation Rule:

Replace the Field Api Name as per your org... 
  
AND(
	ISCHANGED(Stage_Field__c),
	ISPICKVAL(Stage_Field__c, "Old Stage"),
	ISPICKVAL(PRIORVALUE(Stage_Field__c),"Current Stage"),
	NOT(ISBlank(Date__c)) 
)

Replace Old Stage ==> Previous Stage Value
Replace Current Stage ==> Particular Current Stage 

Thanks,
Maharajan.C