Setting a default value in a sheet
Hi Everyone ,
Is there a tip to set a default value in a sheet column ? I know it is possible to do it by a webform , but it is not my concern .
I have a drop-down list column , with 2 items : "Oui " et " Non " . How can I manage so that " Non " value is displayed in the column by default every time a new row is added .
Thank you .
Comments
-
I think that you can set a default value using a form but may not be able to in a smartsheet data sheet
-
You can also take a look at the following thread for ideas
https://community.smartsheet.com/discussion/using-dropdown-list-value-default-new-rows
-
It´s an old thread, but maybe this helps future generations :-)
Having to deal with the same problem I have chosen following workaround:
- include the field in the webform
- set the field to the default value
- set the field to hidden
Hope this helps.
-
Thank you @Carsten Hempelt this has worked perfectly for me.👌👍️
-
Thank you for the tip. I'm trying to get the Status column defaulted to 'Not Started' for any new task added to the sheet (directly in the sheet not through form). I tried the steps you suggested. However it still doesn't get the column to be defaulted. Can you please advice, what I might be missing ?
PS: The column gets the default value when a new entry submitted via form but not when directly adding a row in the sheet
I created a form, just the primary field and the status field.
- included the Status field in the webform
- set the field to the default value (see screenshot)
- set the field to hidden (see screenshot
-
I hope you're well and safe!
You can use a Workflow combined with the Change Cell Action so that when a new row is added, it changes to "Not Started".
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
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
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.
-
-
Excellent! Thanks!
Happy to help!
✅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!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives