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: