Sign Up ›

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

How to use an OR formula?

I have this formula where all 3 fields must be true.  However, the last one Source__c should be OR, not AND.  How to change this?

AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" ),
ISPICKVAL ( Source__c , "Webinar" ))
Terry_0101Terry_0101
more specifically, it should be like:

AND (ISPICKVAL ( Type, "Customer" ),

ISPICKVAL ( Status__c , "New" ),

OR

ISPICKVAL ( Source__c , "Webinar" ))
Jason Reiber [ACS]Jason Reiber [ACS]
What about something like :  AND (ISPICKVAL (Type, "Customer"), ISPICKVAL (Status__c, "New")) || ISPICKVal (Source__C, "Webinar")
Robert ZentgrafRobert Zentgraf
Hi Samantha,

please try this:
OR( AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" )), ISPICKVAL ( Source__c , "Webinar" ))

Regards
Robert

(mindforce: http://www.mind-force.de)