Master Dropdown List (aka using same dropdown on multiple sheets)

AverageUser

We would like to be able to have a single place to manage a "master" dropdown list that can be used to house our everchanging list of clients. We want to be able to use this list on multiple Smartsheets so that when it is updated in the "master", the dropdown selections available are updated on each Smartsheet as opposed to having to manage the dropdown list on each sheet separately.

I searched to see if this was an option and found a few conversations on the matter. But they were either really old (some back in 2015) or inconclusive.

Can anyone tell me if there is any way to do with within the native Smartsheet application? We are on an enterprise license if that makes any difference.

Andrée Starå

Hi,

You can use the Premium add-on, Data Uploader to make it work.

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi,

You can use the Premium add-on, Data Uploader to make it work.

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

AverageUser

That might be a possible solution. I watched the video at:

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

I'll contact solutions@smartsheet.com and get a quote.

Andrée Starå

@AverageUser

Excellent!

You're more than welcome!

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

John Plecki

but does this help changing the data within a dropdown list?

Andrée Starå

Hi @John Plecki

Yes, it can be used to update the data in the dropdown list.

• Update Dropdowns—Replace Smartsheet dropdown values in Column Properties, from values within your Excel or .csv file

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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

Meredith Luschen

This is excellent for ONE drop down, but can you connect the data offloader to multiple sheets using one offload? or do you need to build multiple offloads, one for each sheet with the same dropdown? We have a master list that needs to be a dropdown on 15 or so individual sheets. Thanks!