New Idea
Conditional Statements in Filters
Can we get conditional (If/else if/else) statements in filters? AND and OR logic is helpful, but it would be great to have conditional logic as well.
It is true that some if statements can be handled with some fancy and/or groupings, but this would allow greater flexibility on what to include or exclude.
Having a report that would allow me to say:
IF (X and Y) ELSE (A or B) would be fantastic.
That is a small use case example, but the implications would be much more value for anwhere you use logic to create something: reports (regular and data designer), filters, rules, queries, programs you name it.
And to be clear, I’m talking about adding this in addition to case logic for formula and conditional fields.