You need to sign in to do that
Don't have an account?
Validation rule involving picklist values
Hi I am new to salesforce. I am facing a diffcult situation with a validation rule that is involving picklist values. I have a Picklist field called XYZ category. I have 7 different picklist values like Phase, emergency, authorized, operations, other, members, procedures. Phase, emergency, authorized, operations can be considered as important for the sake of scenario. I want a validation rule that should allow users to pick any of the 7 values in the xyz category which normally happens. I do not want the users to change the category if they once select Phase, emergency,authorized, operations. If they select anything from the other three and they wish to edit and change it to another category the system should allow saving the record. If they change the category from other or procedures or members to the important ones it should allow saving, but if they wish to change from the phase or emergency or authorized or operations to any ther category, the system should not allow saving the record.
I am trying to solve it using Priorvalue, ischanged......but I am not reaching the solution. Can some one help me please...
heres the formula for your validation rule:
IF (PRIORVALUE(TEXT(XYZCategory__c)) == "Phase"
|| PRIORVALUE(TEXT(XYZCategory__c)) == "Operations"
|| PRIORVALUE(TEXT(XYZCategory__c)) == "Authorized"
||(PRIORVALUE(TEXT(XYZCategory__c)) == "Emergency"
, TRUE, FALSE
)
Havent tested.. But should work.
Unfortunately that is not working. Can you help me with a trigger in this case? Thank you for your support.
That is not working. When IF is used the system is not allowing to use OR in the condition, but it is allowing OR in True, False. I have used four different validation rules and the functionality is working now.
Thank You for your help.