IF, Contains, etc. Formula Help

Hello,

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!