Autofill Drop Down menu from Report

I have a PO Request database where I want to have users be able to use a drop down menu to choose the Approved Supplier, from a continually updating list. That list lives on another sheet, however. I cannot imagine that Smartsheet proposes that the only way to update this drop down is via manual fill. Is this correct? Or is there a work around please.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!