Issue with mystery rows moving to a sheet

TroyDunn

Hello all,

I have an automation rule on my sheets to run at 8am every day to copy a row and move it to another sheet if the row has an end date that is in the past. However, only in the past several days (right around 8am), I am getting rows in the destination sheet that have expired dates from the beginning of June. These rows contain a 'Project Name' column that does not match a Project Name anywhere in my sheets. I have also checked all of my sheets and nothing has an expired date in early June. Anyone have any ideas?

Paul Newcome

Have you checked the Activity Log to see if there were any rows inserted via automation "on behalf of" anyone? It sounds like maybe someone else has set up a similar automation and may have accidentally selected the wrong recipient sheet.

TroyDunn

Mystery solved I think. Thanks for your idea Paul as I would need to check with others to see if they copied my automation rule inadvertently since automation rules copy to new sheets by default. I found a copy that I had made a long time ago where I saved the automation rules and I shouldn't have. Thank you for being so quick to respond!

Paul Newcome

Happy to help. 👍️