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
E GE G 

Using OR operator in CASE formula

Hi all,

I'm trying to use Process Builder to change the Case Status upon a custom picklist field modification. I'd like to use the same status for multiple values of the picklist. Was trying to keep the assignment formula clean by using an OR inside the CASE statement but doesn't seem to work.

The formula would look like so:

CASE([Case].PicklistField__c,
    "Value1" OR "Value2", "Status1",
    "Value3" OR "Value4", "Status2",
    "Status3"
)

Thanks in advance!
Eno
Best Answer chosen by E G
E GE G
Hi,

I'm well aware of the standard operation of the CASE function. The question (maybe it wasn't clear) is if there's a way to use some kind of OR operator for multiple values in a single CASE() line.

Thanks,
E

All Answers

Nishad KNishad K
Hi,

Try like this 
  
CASE([Case].PicklistField__c,
    "Value1", "Status1",
    "Value2", "Status1",
    "Value3", "Status2",
    "Value4", "Status2",
    "Status3"
)

Regards,
E GE G
Hi,

I'm well aware of the standard operation of the CASE function. The question (maybe it wasn't clear) is if there's a way to use some kind of OR operator for multiple values in a single CASE() line.

Thanks,
E
This was selected as the best answer
garxu21 joegarxu21 joe
Creating a formula that returns valid data can be a complex task. As the following example shows, you can simplify the process by using the ...TalkToApplebees (https://esurveys.onl/talktoapplebees-applebees-survey/)