Created Date Formula for Forms

ggross
ggross
edited 12/09/19 in Formulas and Functions

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?

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams Top Contributor

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

    Then

    [email protected] + ""

    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 

    [email protected]

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

    I hope this helps.

    Craig

  • ggross
    ggross

    Exactly what I needed - thank you!



    Geneva

  • J. Craig Williams
    J. Craig Williams Top Contributor

    I'm glad.

    Craig

  • Jairo Gomez
    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)))

Categories