You need to sign in to do that
Don't have an account?
Eric Pohlabel
Validation Rule prevent picklist change if priorvalue isnt specific values
My requirement is to only allow users with the profile of "Freelance Writer" to change the value of the Status__c picklist if the current value of Status__c is "Assigned", "Sent For Revisions by Editor", or "Sent for Revision by Client". Here is what I have so far:
AND ( $Profile.Name = "Freelance Writer", ISCHANGED(Status__c), NOT(ISPICKVAL(Status__c,"Assigned")), NOT(ISPICKVAL(Status__c,"Sent for Revisions by Editor")), NOT(ISPICKVAL(Status__c,"Sent for Revisions by Client")))But its not quite right - seems it restricts the user from making change to Status__c even if Status__c is set to one of the acceptable values. Do I somehow need to use PRIORVALUE for this?
So this is a use case which needs two different validation rules for a better user experience. You can create your first validation rule like this to ensure that nobody else apart from users with Freelance writer can change that field.
You are absolutely right in saying that you need to use to PRIORVALUE function to check for the existing values. So your second validation formula would be this to check that Freelance Writer users cannot change the picklist unless it is one of the values defined below.
Kindly mark it as an answer if that resolves your issue !
All Answers
Try this:
-Thanks,
TK
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
So this is a use case which needs two different validation rules for a better user experience. You can create your first validation rule like this to ensure that nobody else apart from users with Freelance writer can change that field.
You are absolutely right in saying that you need to use to PRIORVALUE function to check for the existing values. So your second validation formula would be this to check that Freelance Writer users cannot change the picklist unless it is one of the values defined below.
Kindly mark it as an answer if that resolves your issue !