Dropdown formula to reference another sheet

Options

I am trying to create a formula to accomplish the following.

If 03 is selected from my dropdown, reference another sheet to find out who the manager is of store 03.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!