SWITCH/IF Function Help

Platform discussions Special workflows & use cases
1

Hey Everyone,

I would like to create a SWITCH/IF condition in a formula based on the following logic.

Default behavior is to subtract 5 different number columns from a primary number column (easy to build, already have this working).
Now the switch/if logic:
If “x” column is set to “status1”, then include “y” column in the above subtraction.
If “x” column is set to “status2”, then include “y” and “z” columns in the above subtraction.

Thanks in advance!

2

Hey Shea! It would be super helpful to see screenshots of your current board setup and Numbers Columns in order to test this out and find the right formula for you.

Our support team does have a dedicated group of formula experts that can help you get this set up! Feel free to reach out to us here to chat with them.