Form default to today's date

Phil Wightman

I want a form to default to today's date (date submitted). A previous post (2017) showed how to do this by selecting the 'Today' button on the bottom of the calendar in the field settings of the form. However my calendar does not have a today button.

Andrée Starå

Hi @Phil Wightman

You could add it automatically after the form is submitted.

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Phil Wightman

How @Andrée Starå ?

David Joyeuse

Hi @Phil Wightman

If you want to note the date of the submitted form, I'd rather suggest you to use an automated cell "date created".

Having an hidden field in the form that as this formula within it: =TODAY(), will change date each time you open the sheet, so I believe it won't help.

Andrée Starå

@Phil Wightman

I saw that David answered already!

Let me know if I can help with anything else!

Best,

Andrée

Katie Coulter

Like Phil, I also came across the 2017 help forum post showing "Today" as an optional default. That feature was removed. I understand that I can create a column formula in the sheet that the form populates, but I want the form submitter to be able to change the date if it is NOT today/same day as form submission.

Could that feature be re-instated?

dave.hoffman25926

I too need to default today's date into a date field on a form so I can see how many days it has been since a new ticket is added and has not been addressed.

If anyone has figured this out, it would be great to know. Not sure why Smartsheet removed this feature from the forms.