How to Update a Drop Down List using Data Uploader

Tina Ciak

I recently saw a post saying that you can update a dropdown list in a sheet if you have data uploader.

I do have this, but can someone please tell me how to do this?

Andrée Starå

Hi @Tina@Masco

I hope you're well and safe!

Have a look here.

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

Select a Target Sheet and Upload Action

In this step of the workflow, you will configure how you would like the results uploaded into Smartsheet.

1. Select the target sheet to be updated. (If you are using Smartsheet Attachments as a source, this can be the same sheet or a different sheet from the source sheet.)
2. Choose how you want to import the data into Smartsheet:
   • Replace—Delete all existing data and replace it with the newest data
   • 
     
3. IMPORTANT: Choosing replace will delete all context added including cell links.
4.  
5. Merge—Updates data based on a primary key with an option for you to insert new rows. If you choose this option, you'll also need to select whether to add new rows.
6.  
7. Update Dropdowns—Replace Smartsheet dropdown values in Column Properties, from values within your Excel or .csv file

Did that work/help?

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!

Tina Ciak

Thank you!!!

Andrée Starå

@Tina@Masco 

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!