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 information? 👀 | 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
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!