Where is the "today" default date for forms?

MONIQUE WALL · 07/08/20

In this updated version of SS I don't see the option for "Today" on the calendar. Has this feature been moved or disabled?

SoS | Dan Palenchar · 07/08/20

You cannot add formulas to forms.

The workaround is to simply add the Created (Date) Auto column and use this as it will populate the date/time of when the form was submitted.

You can rename this as you please. If you don't want the time, create a new column with formula =DATEONLY(Created@row)

Bryan Langley · 12/11/20

DAN, this makes no sense as this was an option before. Features need to be added to smartsheet not taken away.

https://community.smartsheet.com/discussion/15621/use-todays-date-by-default-in-web-form

Matt Tancock · 04/27/21

https://community.smartsheet.com/discussion/comment/255932#Comment_255932

The suggestion of "Created (Date) Auto column" is great and seems to work BUT the suggestion to remove the time using =DATEONLY(Created@row) is not working for me...gives me "INVALID COLUMN VALUE" any suggestions here ?

Andrée Starå · 04/27/21

@Matt Tancock

Answering here as well.

Make sure that the column is a Date type column.

Sameer Karkhanis · 04/28/21

@MONIQUE WALL Good catch! I hope Smartsheet team addresses the issue.

jtallman · 06/09/21

I agree that removing this functionality is frustrating. It worked exactly the way I needed. Having to add an additional column just to have this functionality clutters up the sheet. I want fewer columns that do what they need to do not multiple work around columns that have to be used together to achieve the desired end result.

J Harbin · 09/20/21

Update: Never mind! :) I figure it out!

Hello.

I created a new column, type = date, and entered that formula in the first empty cell (then copied it down 10+ rows.). I get "#UNPARSEABLE." When I submit a new form entry, nothing happens in the cell.

Do I just enter this formula in every cell in the column? Can you please explain where you enter the formula?

Thank you.

S.Caleb Thomas · 06/14/23

Here is a suggested workaround, especially if you want the 'Todays Date' cell to still be editable (i.e., backdating or catching up on admin):

In Edit Form use the help text topreference "if submission date is same as performance date, leave blank"
Design an automated workflow when 'Todays Date' is blank, change cell value to "Record a Date"

Where is the "today" default date for forms?

Answers

Categories