0

We want a validation that if users changes the picklist values from previous values to blank or null, an error message should be displayed.

The vaidation rule which I had applied was :

OR(
ISPICKVAL(PRIORVALUE(Verification__c), "Reverification - Pass"), 
ISPICKVAL(PRIORVALUE(Verification__c), "Reverification - Fail") 
) 

&& 

( 
ISPICKVAL(Verification__c, ""))

and have added the error message as : you cannot change the verifiaction to blank once selected.

But this validation rule does not work.

2
  • 2
    try && ISBLANK(TEXT(Verification__c))
    – o-lexi
    Mar 28, 2017 at 23:08
  • Seems like a probable typo in your prior values.
    – Adrian Larson
    Mar 28, 2017 at 23:11

1 Answer 1

0

Try with this,

AND(ISCHANGED( Verification__c ),
    OR(
       ISPICKVAL(PRIORVALUE(Verification__c), "Reverification - Pass"),
       ISPICKVAL(PRIORVALUE(Verification__c), "Reverification - Fail"),
      ),
    ISBLANK(TEXT(Verification__c))
 )

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .