Created Date Formula for Forms
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?
Comments
-
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
-
Exactly what I needed - thank you!
Geneva -
I'm glad.
Craig
-
To convert to date format: =DATE(VALUE("20" + RIGHT(LEFT(Created1, 8), 2)), VALUE(LEFT(Created1, 2)), VALUE(RIGHT(LEFT(Created1, 5), 2)))
Help Article Resources
Categories
Check out the Formula Handbook template!