We’ve now added a new formula function called SWITCH () in Stackby.
SWITCH () is an alternative to IF statement.
Switch matches an expression against a series of pattern values, returning the result value corresponding to the first match. Pattern values must be unique. If no pattern matched returns the default value if specific, else Null.
In short, it makes NESTED IF formulas or formulas with multiple IF conditions, much easier.