How do I populate drop-down values in a column from a different SmartSheet?

I want to create drop-down field in SmartSheet A that will get its values from a column in a different SmartSheet (SmartSheet B). As I add or remove values to/from the referenced column in SmartSheet B, I want these values to show up or drop off from the drop-down values in SmartSheet A. Any ideas how I can do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!