Updating dropdown list across various sheets
Hi all,
I have a same column across different sheets, and the column dropdown needs to be updated frequently, which I am manually updating right now. However, I do have Data Shuttle feature that I can use to update the dropdown lists. To test this feature, I have created a source and destination sheets, and after creating offload and upload workflows, any additions made to source sheet rows are not updating in the destination sheet dropdown column, can anybody please help me understand why is this happening?
And also, can I link the same source sheet to different destinations sheets (that are using same dropdowns) at a time or do I need to create workflow for each single sheet?
Thanks,
Mounika
Answers
-
Hi @Mounika
Can you post screen captures of how you set up the DataShuttle workflows, the settings selected on the tabs? (Block out any sensitive data). The Upload workflow should look something like this:
You will need to create a new workflow each time you're updating a new sheet, but you can use the same trigger (so the same offload workflow that creates a file that the multiple upload workflows then use, does that make sense?)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!