IF, Contains, etc. Formula Help
I am trying to come up with a formula to make my automations easier. Basically, I have a dropdown column with 35 different options (single-select). If a person chooses a certain option, I need to notify a certain approver (1 of 5 people). What would be the best way to set-up a formula for this? Will I need to write out a huge formula with all 35 choices?
Help Article Resources
Check out the Formula Handbook template!