Dropdown formula to reference another sheet


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!