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
jsacpt24jsacpt24 

Validation Rules not letting a a Picklist go backwards in value

Hello all, 

I am trying to create a validation which will stop users from either skipping forward (changing value from A to C) or going backward (changing value from C to B). For some reason I keep getting an error on this. Any advice on these? 
Andy BoettcherAndy Boettcher
What error are you getting?

Also, please post your validation rule in here using the "< >" code formatting button.
GauravTrivediGauravTrivedi
Hi Chris,

You can use the following validation 
ISCHANGED( fieldName__c)
let me know if it works.
 
Andy BoettcherAndy Boettcher
Guarav,

It's difficult to recommend a solution when you dont' know what the problem is.  =)
kryzkryz
AND(
ISCHANGED(PicklistName__c),
TEXT(PRIORVALUE(PicklistName__c)) = "A",
TEXT(Rating) <> "B"
)

and so on...