Copying data from Summary Sheet to another sheet
We use the summary sheet of project plans for PMs to update the overall RAG and add any specific comments about the project and it gets pulled to Dashboard for reporting.
However, I am also trying to create a repository of "overall status RAG" to observe if there is a trend over the life of the project. To do this, I referenced the cell from the summary sheet to the project plan and set up an automation to copy the row to a new sheet . The automation runs, but the data never copies to the new sheet. What could be going wrong? Is there a different way to get this data to the Weekly RAG sheet.