Having an IFS statement that works like the IFS statement in Excel would be great.
For those who don't know how this works, it is as follows:
=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)
It is processed from left to right so once it finds the first true condition it exits. I use this all the time in Excel rather than nesting many if statements. If I need an ELSE condition, I just use it like this:
=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3,0=0,Value if none of the previous condtions are true)
This function saves nested if statements that can be many levels deep.
