Set due date based on date form was submitted

How can I auto-populate a column to set a due date 5 days after the form is submitted?

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    There is a system column for Created Date. Add that to your sheet. This will be populated with the date the row was created (which will be when the form was submitted if a row was added via a form).

    Then you can add another column with the formula

    =Created@row + 5.

    (replace Created with whatever you call the column, use [ and ] if this has spaces in)

    Make this column date format and convert the formula into a column formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!