How can I get a due date to automatically populate in a cell 10 days from the day a row is created?
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!
Best Answer
-
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
Answers
-
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
-
Thanks Paul!
-
Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!