If Formula that Autopopulates names

Hi! I need help with a formula that would do the following......

If John Smith was a Client Services Director that was assigned to two states (AL and LA), which formula would I use to populate his name into the column adjacent to the state every time either AL or LA was inputted into the "State" column? And would those names need to be options in the dropdown, or would that complicate matters?

Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!