Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Terry_0101Terry_0101 

Multiple OR statements in formulas

How to make this validation rule work?

ISPICKVAL ( Products__c, "ABC"),
OR
ISPICKVAL ( Products__c, "DEF"), 
AND
ISPICKVAL (  StageName , "Evaluation")
OR
ISPICKVAL (  StageName , "Negotiation")
OR 
ISPICKVAL (  StageName , "Sale Pending"),
ISBLANK(TEXT( Cash_Flow_Forecast_report__c )) 
))))
Best Answer chosen by James Loghry
Terry_0101Terry_0101
I got it to work:

AND ( 
AND ( 
ISPICKVAL ( Products__c, "ABC") 
|| 
ISPICKVAL ( Products__c, "DEF"), 
ISPICKVAL ( StageName , "Evaluation") 
|| 
ISPICKVAL ( StageName , "Negotiation") 
|| 
ISPICKVAL ( StageName , "Sale Pending"), 
ISBLANK(TEXT( Forecast_report__c )) 
))