You need to sign in to do that
Don't have an account?
jsacpt24
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?
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?
Also, please post your validation rule in here using the "< >" code formatting button.
You can use the following validation let me know if it works.
It's difficult to recommend a solution when you dont' know what the problem is. =)
ISCHANGED(PicklistName__c),
TEXT(PRIORVALUE(PicklistName__c)) = "A",
TEXT(Rating) <> "B"
)
and so on...