Does anyone know of a way to automatically update a Drop-Down List?
I have managed to used Data Mesh to send data from one sheet to another but there doesn't seem to be a way of updating a dropdown list. i.e. we give users a dropdown list of project and budget codes but every time I add a project, I have to update all the sheets which lookup project codes.
Any ideas?
Thanks
Viv
Best Answer
-
Hi @Vivienne Strettle ,
We have developed Smarter Dropdown list manager which allows you to control the content of multiple dropdown lists in different sheets all from one central point. This is part of our SmarterControls4Smartsheet range of Apps designed to help Smartsheet users work more efficiently. https://smarterbusinessprocesses.com/smartercontrols4smartsheet-dropdown-list-manager-c/
Let me know if you would like to know more.
Best regards
Gwen
Answers
-
Hi @Vivienne Strettle ,
We have developed Smarter Dropdown list manager which allows you to control the content of multiple dropdown lists in different sheets all from one central point. This is part of our SmarterControls4Smartsheet range of Apps designed to help Smartsheet users work more efficiently. https://smarterbusinessprocesses.com/smartercontrols4smartsheet-dropdown-list-manager-c/
Let me know if you would like to know more.
Best regards
Gwen
-
Yes please Gwen. It's part of work I'm doing for a client. Very interested.
Viv.
Viv@kvsconsultingservices.com
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I thought combining the four different sheets into one report would eliminate the need to share all four separately. However, I was just informed that they're unable to see the context of the report, …
- Hello, I created a smartsheet with a form, and when I saved this smartsheet as a new file so I could keep the template, I can't get the form to show on the left hand side of the screen for easy access…
- I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is…
