Update Dropdowns - Data Shuttle

jerry123

Hi all,

I have an intake sheet with all of my projects in the pipeline and I have time sheets for around 50 users. Each user can have as many projects assigned to them that they are tracking time towards (this all resides in their respective time sheets). I want the list of projects from the intake sheet to show as dropdown options in the "Project Name" column in their timesheets. Can I achieve this through data shuttle? If that's the case, I will have 50 offload workflows and 50 upload workflows? Since I have to offload the csv from the intake sheet and upload the intake sheet to the timesheet. Is this the right way?

Appreciate the help!!!

Andrée Starå

Hi @jerry123

I hope you're well and safe!

Yes, you can use Data Shuttle for that, and no, fortunately, you don't have to create two workflows for each.

Have a look at this guide.

Create dynamic dropdowns with Data Shuttle | Smartsheet Learning Center

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

Dynamic dropdowns can automatically update a dropdown list in one location when that list has changed in another location. 

Make sense?

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!

jerry123

@Andrée Starå This works thank you!!! :)

Andrée Starå

@jerry123

Excellent!

Happy to help!

✅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!