You need to sign in to do that
Don't have an account?
jisaac
prevent a picklist from being changed if it already shows a particular selection
I have a picklist with three options:
"Requested by Sales Ops"
"Successful"
"Failed"
I am trying to create a validation rule that prevents this from being changed if it already is listed as "Successful".
Here's what I have so far but it kicks in regardless of the change in the field - not just when it already shows "Successful".
NOT(AND(ISCHANGED( Opp_FMS_Integration__c ),
ISPICKVAL( Opp_FMS_Integration__c , "Successful")))
Any suggestions?
Jane
"Requested by Sales Ops"
"Successful"
"Failed"
I am trying to create a validation rule that prevents this from being changed if it already is listed as "Successful".
Here's what I have so far but it kicks in regardless of the change in the field - not just when it already shows "Successful".
NOT(AND(ISCHANGED( Opp_FMS_Integration__c ),
ISPICKVAL( Opp_FMS_Integration__c , "Successful")))
Any suggestions?
Jane
Here you go
AND( ISCHANGED(Opp_FMS_Integration__c ), ISPICKVAL(PRIORVALUE(Opp_FMS_Integration__c ), "Successful"), NOT(ISPICKVAL( Opp_FMS_Integration__c, "Successful")) )
All Answers
Here you go
AND( ISCHANGED(Opp_FMS_Integration__c ), ISPICKVAL(PRIORVALUE(Opp_FMS_Integration__c ), "Successful"), NOT(ISPICKVAL( Opp_FMS_Integration__c, "Successful")) )