Switch Statement with multiple columns and conditions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ...
- Labels:
- Custom Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
