How to source a Drop Down list from a column in a Report?

I have a "PO Request" sheet where I want a drop down list of Vendors to be pulled in from an ever refreshing report of Approved Vendors. It seems incredible that this drop down has to be updated manually. Is this really true or is there a workaround?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!