Update completed date on different sheet after form submission

Felipa

Hello All,

I have a form collecting construction progress updates. When a from is submitted, I would like the "Construction Report" on a separate sheet to have a completed date (equal to submission date on the form) entered automatically. We can assume that the forms will be submitted and kept in sequential order.

I have played around with automations, cell linking, and index formulas, but can't figure this one out. Would love to know if anyone has any solutions to make this possible.

Thanks!

Form Set Up:

Task List Sheet:

Matt Lynn#

@Felipa I've done this type of things many times. The easiest way in my opinion is to
1.) Either use the created column or a date column that is populated by an automation on the submitted date.
2.) Have a helper column (hidden) flag the row that has the latest or most chronological submission.
3.) On the second sheet do a index(match()) to pull in the row with the flag and display that date.