Why am I no longer able to see one of my sheets to copy rows to?
I have a Automation workflow set up to copy rows from one sheet (Sheet A) to another (Sheet B), both of which I am an admin for, but all of a sudden, the automation is no longer working and I cannot see sheet B as an option to copy rows to. The issue seems to be with the sheet A, as in other sheets I own (Sheet C), I am still able to select sheet B.
Workflow in Sheet A:
Workflow in Sheet C:
Can anyone advise on how to troubleshoot?
Best Answers
-
Hi @Alexis Goes
I agree with @AYarrington! It sounds like the current Owner of this Sheet A (the Owner of the Workspace) is no longer shared to Sheet B. (See the Note at the top of this article: Automatically Move or Copy Rows Between Sheets)
I would check Sheet B and make sure you share it with at least Admin permissions to the user in your screen capture above.
Cheers,
Genevieve
-
Thank you @Genevieve P. and @AYarrington for your suggestions!
Answers
-
For a sheet to be selectable as a destination sheet, both the person setting up the workflow and the owner of the source sheet need to be admins on the destination sheet. Are you the owner of Sheet A?
-
I'm not the owner of Sheet A, but an admin. I wonder if it has something to do with the workspace.
-
Hi @Alexis Goes
I agree with @AYarrington! It sounds like the current Owner of this Sheet A (the Owner of the Workspace) is no longer shared to Sheet B. (See the Note at the top of this article: Automatically Move or Copy Rows Between Sheets)
I would check Sheet B and make sure you share it with at least Admin permissions to the user in your screen capture above.
Cheers,
Genevieve
-
Thank you @Genevieve P. and @AYarrington for your suggestions!
-
The issue was indeed that the owner of Sheet A was not an admin or owner of Sheet B. Once I shared Sheet B with the owner of Sheet A the issue was resolved.
-
Thanks for following-up! I'm glad that this has been resolved for you. 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!