Auto refresh dropdown list
Is it possible to link dropdown list choice to a specific column in a specific sheet?
That would be really helpful to update automatically the dropdown list.
Thanks for your support
Best Answer
-
Hi Jerome,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi Jerome,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andrée for your time, I just submit it to Enhancement Request. Hope they will create this update which could help many of them.
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I agree - I use Named Ranges or Tables in Excel to do this all the time and it enables dynamic options, with changes or additions on the fly. One obvious example is that you could receive a list of names via a form, and then use it to create a dynamic drop down list for allocating people to tasks. Excel Tables are useful in this way because they can grow, and you don't have to predict how many entries you may have. It would be great if Smartsheet could do similar.
-
I like this idea. I have several workspaces with multiple sheets that use dropdown lists referencing the same list. This feature would allow me to update all the lists once saving time and potentials errors if I forget to change a list.
-
I have idea to automatic update and recalculate formulas via API, I made one tool work in background.
-
Hi Rasik, good to here that. What does it mean you create an interface on side of Smartsheet to allow a dropdownlist refresment?
-
Hi, Thanks for all your answers.
Rasik, is it possible to upload your soft?
Smartsheet admin, Are you aware about this request which seems to be more than useful. Please can you implement it to next Smartsheet update?
Again thank for your time and help.
-
You're more than welcome!
I forgot to mention that there already is an option in Smartsheet that would be perfect for this use-case.
The premium add-on, Data Uploader.
Is that an option?
More info:
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée,
Thanks, you are always fast to answer. I can not have access to data uploader, I tried many way but it is not working. I'll wait answer from smarsheet admin about it.
Question: does data uploader will allow to put names in a drowpdown list cell and add new entry automatically?
The column with dropdowlist (customer name) is in more than 5 sheets. My goal is to update all those list automatically when the customer name is not existing.
Best regards.
-
Thank you for the solution , I was also looking for it.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Any indication asto when this would become a reality within smartsheet ?
-
Hi,
I come back on this topic, I find an answer with 'DropDown Update for Smartsheet' but it is not free.
Any news from Smarsheet development team?
Best regards.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!