Column Dropdown

Jonnie White

Does anyone know of a way to auto populate column dropdown values? Or at least a work around so that I don't have to update 50 columns every time the values change!

Andrée Starå

Hi @Jonnie White

There are a couple of workarounds.

-A solution that could be perfect for this use-case is the premium add-on, Data Uploader.

More info: 

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

-Another option could be a 3rd party solution.

-There are also ways to simplify the manual process. Master Directory that you then copy to the different drop-down lists.

Would any of those options work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

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 @Jonnie White

There are a couple of workarounds.

-A solution that could be perfect for this use-case is the premium add-on, Data Uploader.

More info: 

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

-Another option could be a 3rd party solution.

-There are also ways to simplify the manual process. Master Directory that you then copy to the different drop-down lists.

Would any of those options work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

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!

Jonnie White

Thanks @Andrée Starå appreciate your help

I'm currently using the 3rd option you've suggested so I'll investigate options 1 and 2.

Kind regards,

Jonnie

Andrée Starå

@Jonnie White

You're more than welcome!

Brandon Berg

Is there specific functionality in the Data Uploader module that enables "dynamic lists" specifically? What would that workflow look like?

Andrée Starå

Hi @Brandon

Yes, but not totally automatic.

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

https://help.smartsheet.com/learning-track/integrations-and-add-ons/data-uploader

Would that work/help?

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!

PPS Solutions

@Jonnie White Hi Jonnie, take a look at our solution here which will give you the capability you need - https://projectplanservices.co.uk/dropdownsync Feel free to contact us if you would like to trial this.

Thanks PPS

Jonnie White

@PPS Solutions Thanks, I've completed the enquiry form on your website