Copy Row Automation
I have been tasked by my team's leadership to create a way that they can audit how often my colleagues are updating their project plans.
We currently have a "Master Sheet" that lists all of our current projects and certain cells linked in from each project plan. The project manager is supposed to be updating their executive summary weekly. There is a column in the project plan called "Exec Summary Update" where the PM manually changes the date to the date they've updated their summary. This cell is then linked to the project plan.
I thought it could build an automation to copy the row to a new "Audit of Master Sheet" sheet whenever the "Exec Summary Update" column is changed.
I ran my test, but nothing copied over to the Audit sheet. I scrolled to the bottom and nothing is there. I suppose my first question would be if we're even able to trigger an automation off of a linked cell?
If so - what any idea on what is going wrong?
If not - any suggestions on a better way to do this?
Note: the goal of the audit is for the leadership team to be able to see every time a person updated their executive summary. For example: if I updated my "Audit Testing" project's executive summary today, and then again tomorrow, the Audit sheet would show my project in two rows with each date. Then leadership could go into the Audit sheet, filter by my name, and see that I updated my exec summary twice.
Any thoughts or suggestions are most welcome! Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!