How to use a smartsheet to update the form dropdown values in another smartsheet?
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!