I have task sheet of items that are completed on a monthly basis. The plan was to use one row to track the task, capture who completed the task and when, and auto populate the due date for the next month.
I created an automation so when the done box is checked, the last date completed on column would automatically populate, and used a formula (=[Last Completed On]@row+29) to populate the next due date. I scheduled an automation to copy the row to another sheet for historical reference, but it doesn't work. Is there a better way to do this? Should I use another trigger for the copy automation?
Here are my columns:
Here is the automation to copy the rows:
