Set due date based on date form was submitted

Laurie Ajan

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

KPH

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.

KPH

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.

Laurie Ajan

Thank you!

KPH

You’re welcome @Laurie Ajan