Update Dropdowns - Data Shuttle
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!!!