[SalesForce] Validation rule to prevent user changing a picklist value

I have a picklist Advancement which has values Stage 1, Stage 2 and Stage 3. I want users (except for System Admins) NOT to be able to go from Stage 1 to Stage 3.

I have written the following validation rule:

AND( PRIORVALUE( ISPICKVAL ( Advancement, "Stage 1") ),  ISPICKVAL(Advancement, "Stage 3")  )

The validation rule does not work, as the syntax is incorrect. However, I cannot think how I can express that I want to disallow a certain value if another was selected previously.
Tia, Lily

Best Answer

Try this:

AND( ISPICKVAL( PRIORVALUE ( Advancement__c), "Stage 1"), ISPICKVAL(Advancement__c, "Stage 3"), NOT ($Profile.Name = "System Administrator") )

Related Topic