Dropdown list Default value
Hello,
I have a dropdown list of 10 values, simply a Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly.
Is there a way i can set the dropdown list to select "yes" as the default value?
Thanks
Andrew
Comments
-
Hi Andrew,
Unfortunately, it's not possible at the moment in the sheets, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to use a form instead because in the form you can set a default value.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Hello Andree,
Thanks very much for your response....a form isnt really possible. It's a shame there isn't a tick box or something when you are creating the dropdown list which is "set default value" and you can select one of the values in the dropdown list.
Guess it goes into the list of Smartsheet improvements
Thanks
Andrew
-
Happy to help!
This might help!
Depending on your structure, you could add the value to all cells or use a combination of columns to select the default value if nothing else is in the cell.
What do you think? Would that help/work?
Best,
Andrée
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.
-
Hey Andree,
Yes that might work - will try it out. Otherwise going with the failsafe method of just keeping it simple
Thanks
Andrew
-
Excellent!
Let me know how it goes!
Simple is good!
Best,
Andrée
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.
-
It's been nearly four years. Any chance this request has made it into production now? thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!