How can I get a due date to automatically populate in a cell 10 days from the day a row is created?

Brandt Monette

We currently use a sheet to track warranty construction items. A form automatically creates a new row under our warranty sheet with columns such as due date, claim number, item, address, name, email and so forth. When this row is created by a form being filled out we want the due date column cell to automatically generate 10 days from the creation of the row.

Any help would be great!

Paul Newcome

You are going to need to add two columns. A system generated Created (date) column, and a Date type column. In the date type column, you are going to want to use something along the lines of...

=DATEONLY([Created Date]@row) + 10

Paul Newcome

You are going to need to add two columns. A system generated Created (date) column, and a Date type column. In the date type column, you are going to want to use something along the lines of...

=DATEONLY([Created Date]@row) + 10

Brandt Monette

Thanks Paul!

Paul Newcome

Happy to help! 👍️