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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!