In our Case process builder, we current have a step where the status is set automatically depending on the value of a custom picklist field. The formula looks like this:
CASE([Case].CaseOutcome, 'Outcome A','Status A', 'Outcome B','Status A', 'Outcome C','Status B', 'Outcome D','Status C', …. New)
There are three potential status types to be assigned and this formula, but a vast number of new outcomes have been added recently and we are in danger of breeching Process Builders 3900 character limit.
There are currently 85 outcomes to assign a status to;
55 will be given status A 20 will be given status B 10 will be given status C
What I am trying to do is change the formula so it will say something like this;
IF outcome = C, assign status B, ELSEIF outcome = D, assign status C, ELSE assign status A
I have managed an IF formula which will cover status B and A but not status C. Here is a sample of that formula;
IF((ISPICKVAL([Case].CaseOutcome__c, 'Outcome 1') || ISPICKVAL([Case].CaseOutcome__c, 'Outcome 2') || ISPICKVAL([Case].CaseOutcome__c, 'Outcome 3'), 'Status B', 'Status A')
This works perfectly EXCEPT, there is no way to assign status C.
I have looked through Salesforce formula documentation but haven't found a satisfactory solution. There doesn't seem to be an IF ELSEIF ELSE type formula, which is maddening and would be the exact solution I am looking for.
If anyone has encountered this issue themselves, I would love to hear how you got around it.