I am not able to select a sheet when trying to set up automation to move a row after status change.
I created a sheet where all of our completed tasks can be archived. I then tried to set up the automation to move the row when the status has changed to completed. Once I get down to select sheet there is no sheet available for me to choose from even though I have numerous sheets saved, and one created specifically for completed tasks, they just down't show.
Thanks,
Gerlinde
Answers
-
Hi Gerlinde,
Are you the owner of the original sheet that you're moving the rows from? If you're only the Admin on that sheet, you need to share the owner to your new, archived sheet as well. You can only copy/move rows to a sheet where the owner is present (essentially you can't set up rows to be "stolen" from an owner, they have to see where the rows go to). Does that make sense?
You can read about this in our Help Center on Automatically Moving Rows (see here).
Let me know if sharing the owner to that other sheet has resolved your issue or not!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
I was the Admin for the sheet the rows were moving off, but I did not share the sheet the rows were moving to which seems to have been the issue.
Thank you very much for your help.
Gerlinde
-
No problem! Glad you sorted it out 🙂
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives