Setting a default value in a sheet

ALAIN-STEPHANE

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 .

ricki

I think that you can set a default value using a form but may not be able to in a smartsheet data sheet

ricki

You can also take a look at the following thread for ideas

https://community.smartsheet.com/discussion/using-dropdown-list-value-default-new-rows

 

Carsten Hempelt

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.

Awesomas

Thank you @Carsten Hempelt this has worked perfectly for me.👌👍️

Sharif_Akkara

@Carsten Hempelt @Awesomas

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

Andrée Starå

Hi @Sharif_Akkara

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!

Sharif_Akkara

@Andrée Starå , Thank you ! That is a great solution. Works like a charm !

Thanks

Sharif

Andrée Starå

@Sharif_Akkara

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!