+ Start a Discussion
DODO 

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!

Best Answer chosen by Admin (Salesforce Developers) 
DODO

this works, thanks!

 

All Answers

VJSFDCVJSFDC

hi 

try this,

 

 

AND (AND (ISPICKVAL(StageName, "Closed/Won"),ISPICKVAL(Opportunity_Type__c,"License/Maintenance")), ISPICKVAL(Acceptance_clause__c, "TBD")) 

DODO

this works, thanks!

 

This was selected as the best answer