Switch Statement with multiple columns and conditions

[nsarayar]

Hi

Is it possible to have a switch statement that uses multiple columns and conditions or am i best using multiple IF statements

So i want my condition to be

If CaseComment or ReviewNotes contains "REJECTED BY FCR" then Referral Reason = "REJECTED BY FCR"

If CaseComment or ReviewNotes contains "REJECTED BY ESR" then Referral Reason = "REJECTED BY ESR"

If CaseComment contains "ESCALATION" and ReviewNotes contains "Unclear Reason" or if CaseComments contains "Unclear Reason" then Referral Reason = "UNCLEAR REASON FOR ESCALATION"

There 20 additional rules ...

[IraWatt]

Hey @nsarayar,

Switch statements can have one value:

Switch(Value,Default,Case1,Result1,...,CaseN,ResultN)

This would mean you would have to create a value for each of your conditions which would be very had to understand logic.

You could try using the find and replace tool as that would avoid nasty IF statements:

Though with the logic above I'm not sure how well that would work.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com