You need to sign in to do that
Don't have an account?
PB14
Validation Rule - If picklist value is a, b, or c then it can not be changed to X
Hello,
I have a picklist field that contains values A-Z. I need to write a validation rule that says if the Picklist is set to A, B or C then the same Picklist can't be changed to the value X but can be changed to other values.
OR(
AND(
ISPICKVAL(PRIORVALUE( VPM_Field__c ),"A"), NOT(ISPICKVAL(VPM_Field__c,"X))
),
AND(
ISPICKVAL(PRIORVALUE(VPM_Field__c),"B"), NOT(ISPICKVAL(VPM_Field__c,"X")))
),
AND(
ISPICKVAL(PRIORVALUE(VPM_Field__c),"C"), NOT(ISPICKVAL(VPM_Field__c,"X")))
)
The above is what i have but it doesnt work
Thanks
I have a picklist field that contains values A-Z. I need to write a validation rule that says if the Picklist is set to A, B or C then the same Picklist can't be changed to the value X but can be changed to other values.
OR(
AND(
ISPICKVAL(PRIORVALUE( VPM_Field__c ),"A"), NOT(ISPICKVAL(VPM_Field__c,"X))
),
AND(
ISPICKVAL(PRIORVALUE(VPM_Field__c),"B"), NOT(ISPICKVAL(VPM_Field__c,"X")))
),
AND(
ISPICKVAL(PRIORVALUE(VPM_Field__c),"C"), NOT(ISPICKVAL(VPM_Field__c,"X")))
)
The above is what i have but it doesnt work
Thanks
OR(
AND(
ISPICKVAL(PRIORVALUE( VPM_Field__c ),"A"), ISPICKVAL(VPM_Field__c,"X")
),
AND(
ISPICKVAL(PRIORVALUE(VPM_Field__c),"B"), ISPICKVAL(VPM_Field__c,"X")
),
AND(
ISPICKVAL(PRIORVALUE(VPM_Field__c),"C"), ISPICKVAL(VPM_Field__c,"X")
)
)
Then again, it might not.