Sometimes i need to add new data to a dropdown list but it's hard for me to add because it's in a lot of different sheets.
How do i automatically add data to all dropdown list column? (Python, Automation, Make, Zapier etc.)
Hi @Emre Gül
I hope you're well and safe!
You could use the Premium App, Data Shuttle, or the Smartsheet API, or something like the 3rd-party service Zapier or something similar.
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thank you for your response @Andrée Starå
I want to automatically change the dropdown list values. I don't want to enter the values manually
Happy to help!
Can you elaborate on how you'd like it to work?
Do you want to update the dropdown list options in multiple places?
@Andrée Starå Yes, this is exactly what i want. But not manually, only automatically
Then some of the options are.
Here's a guide with Data Shuttle that I usually use in my client solutions. (one sheet gets updated that, in turn, updates all options where needed)
Are any of those an option?
✅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!
Has anyone done this using Zapier? I'm sure there are a load of uses for DataShuttle, I've tested it and it works well. But its a chunk of change just to have drop-down dynamically updated, and we're already using Zapier.
@Emre Gül @Craig F
Alternatively you can get an off the shelf add-on that is purpose built just for this. I happen to offer such an add-on, and is within the budget of most businesses.
Read about it and see a demo here:
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.