You need to sign in to do that
Don't have an account?
DO
Validation Rules
I'm trying to create a validation rule where a license opportunity can't be closed won if the acceptance clause still has TBD (it's a required field as well):
I was testing different formulas but they don't seem to be working, I tried the IF validation too but that one was just not letting me close anything at all. Below is a sample of the latest one I tried:
AND (AND (ISPICKVAL(StageName, "Closed/Won"), (ISPICKVAL( Opportunity_Type__c,"License/Maintenance")), NOT(ISPICKVAL(Acceptance_clause__c, "TBD")))) |
Please advise, thanks!
this works, thanks!
All Answers
hi
try this,
AND (AND (ISPICKVAL(StageName, "Closed/Won"),ISPICKVAL(Opportunity_Type__c,"License/Maintenance")), ISPICKVAL(Acceptance_clause__c, "TBD"))
this works, thanks!