restrict users from changing certain picklist values, using validation rules

Question

I am trying to restrict certain users to restrict changing few picklist values, But they are still able to change the picklist.

AND(
    RecordType.Name ='Banker',  $UserRole.Name = 'Executive', ISCHANGED(StageName__c),
    OR(
ISPICKVAL(PRIORVALUE(StageName__c), 'Reviewing'),
ISPICKVAL(PRIORVALUE(StageName__c), 'Required Docs')
)
)

But the user with Executive Role can still change the stageName picklist to reviewing, can someone let me know where am I going wrong, thanks.

Answer 1

Your validation rule is set up to prevent changing the StageName__c field away from "Reviewing" or "Required Docs". If you want to impede changing to those stages, you don't need PRIORVALUE(), which is providing the value of the field prior to the change that's being attempted.