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

Matthijs Schoots · 09/15/22

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?

Lynette.Smith · 09/15/22

HI- I believe DataMesh can help with updating your dropdown details. Or Bridge, if you have it. Bridge is more technical to set up though.

Leibel S · 09/15/22

@Matthijs Schoots

It seems incredible because it is. Smartsheet has been avoiding this for years.

Below are official open ideas 'On Wishlist' that would fix this. Please vote

https://community.smartsheet.com/discussion/92421/dynamic-dropdowns

https://community.smartsheet.com/discussion/93204/datasources-for-dropdown-menus

marc4 · 09/15/22

Data Shuttle will do this. Export the list of vendors to a csv attached to the PO Request sheet, then another Data Shuttle to import the csv to the pulldown for the column you want.

The one trick is that if you want to have the list sorted you have to remember to sort the source sheet. We get around this by using the Smartsheet API and have a job that runs every hour to sort the sheet,'

/marc

Andrée Starå · 09/15/22

Hi @Matthijs Schoots

I am answering here as well!

I hope you're well and safe!

I recently developed a solution for a client where the Dropdown lists are kept updated using the premium app Data Shuttle.

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matthijs Schoots · 09/19/22

Hi Andree, do you have a link where I can learn about this data shuttle and how to set this up please. cheers matthijs

Matthijs Schoots · 09/19/22

sorry I found the link quick enough. How much does this cost please? Any ideas. I'd rather not contact the sales people to find out if I can avoid it.

Andrée Starå · 09/19/22

@Matthijs Schoots

Excellent!

You're more than welcome!

Feel free to reach out at andree@workbold.com, and I'd be happy to help you with the Data Shuttle license and more.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matthijs Schoots · 09/19/22

How much does this Data Shuttle cost please? Any ideas.

Andrée Starå · 09/19/22

@Matthijs Schoots

I need more information before I can answer, and it's best to take that outside of the Community.

Formulas and Functions

Formulas and Functions

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

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA