Created Date Formula for Forms

ggross

Is there a formula that will capture the created date for new entries on a form?  Once the form is completed, I would like a column to automatically populate the day that row was added from the form so I can track response times.  Is there anything like that available other than the audit log?

J. Craig Williams

If the [Created] system column is not displayed, add it.

Then

=Created@row + ""

will show the entire date/time stamp. Note that this is TEXT and not date/time. You'll need to parse out the times to numerically determine response times.

and 

=Created@row

in a Date column, will return the date (as a date)

I hope this helps.

Craig

ggross

Exactly what I needed - thank you!



Geneva

J. Craig Williams

I'm glad.

Craig

Jairo Gomez

To convert to date format: =DATE(VALUE("20" + RIGHT(LEFT(Created1, 8), 2)), VALUE(LEFT(Created1, 2)), VALUE(RIGHT(LEFT(Created1, 5), 2)))