Update Dropdown List Options
Are there any recommendations on how to maintain dropdown options for a Control Center template?
We have a Change Log template where one of the columns is 'Impacted Applications' with a dropdown column property. The list of options change periodically and each time that list changes, we currently need to rollout a global update.
Is there a way to link that dropdown to a single source that we can maintain? Either through Data Table, or any other option?
Answers
-
Hi @Dharitri
Data Shuttle can be used to update drop downs from 1 centralized list. However, it has to be configured for each sheet after the project is created and is priced in Workflow bands so depending on how many projects you have and the length of those projects, this might may or may not be a great solution.
Here is the help article on this topic. I set one up recently and was suprised how quick and easy it was.
I hope that helps.
Matt
-
Hi @Matt Johnson - Thanks for the note. We do use Data Shuttle today for dropdown updates and totally agree, it's a great feature! Unfortunately, we're looking for a good solution for dropdown list updates for a control center template once it's been provisioned (without require global updates). Doesn't seem like it's possible from what I've come across on the solution suite so far.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives