How to use a smartsheet to update the form dropdown values in another smartsheet?

OORF

I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity.

I was going to use data shuttle, however there is not an upload data from a smartsheet option that I see, only upload from a smartsheet attachment or one drive, google drive.

I also thought perhaps I could use a workflow automation since both sources are smartsheets, but I am not finding a workflow that will update form dropdown values via an employee table located in a separate smartsheet.

Any guidance or ideas would be greatly appreciated!

Andrée Starå

Hi @OORF

I hope you're well and safe!

Yes, you can use Data Shuttle.

I'll get back to the post with a help article that explains it.

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!

Andrée Starå

@OORF

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

OORF

@Andrée Starå Thank you!

Andrée Starå

@OORF

You're more than welcome!

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