Move rows to new sheet
Hello,
I am trying to set up an automation that moves rows from one sheet to another, I have successfully done it with the Copy automation but need to move the rows this time. When trying to set it up and I select which sheet it will go to, the sheet I decided was not there. Only two sheets showed up but neither was the one I wanted it to go to. Is there something more I need to set up in order to see the sheet it needs to go to?
Thanks in advance!
Answers
-
Hi @Desertbird
It sounds like you're an Admin on the current sheet where you're building the workflow, is that correct? If so, you'll just need to make sure that the Owner of this current sheet is shared on the other sheet with Admin permissions as well (essentially you can't steal rows away from the Owner, they need to have access to the destination location).
Once you've shared the Owner to the other sheet, it should appear as an option to select in your workflow.
See: Automatically Move or Copy Rows Between Sheets
Cheers!
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!