function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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 )) 
))