Limitations of Copying Rows
I have a sheet for each project my company works for. I am an admin on all of these sheets. We want to create an automation that copies the line to a separate sheet when a checkbox is checked. The idea being that the line in each sheet is copied to this separate sheet when a Project Manager directs someone to work on that line as a sort of log of directives. I created this Directive Log sheet. I attempted to create the automation in multiple sheets. When I went to select the target sheet, Directive Log, it wasn't listed in the options. There were sheets available in my Sheets list as well as well as Workspaces, but the Directive Log was not there. I tried multiple sheets and had the same result. I then saved the sheet as new and I was able to create the automation. Is there a limitation to copying rows that I am not aware of? Do I need to be an owner to copy lines? I would greatly appreciate your help with this.
Help Article Resources
Check out the Formula Handbook template!