Why can't I find the sheet destination

Bri Jarosz

Hi, I'm trying to create an automation that allows me to copy information from one sheet into the other. I have admin/owner permissions on all sheets that I'm working with. Why, when I'm creating the automation and get the "Select a destination," am I unable to find any of my sheets?

Paul Newcome

Each owner needs to be admin or owner on BOTH sheets.

Bri Jarosz

So, I am an admin or owner on all the sheets I'm working with. So, everyone it's shared with needs to be an admin or owner for it to work?

OR

I need to add everyone the one sheet is shared with to the new one I created in order to get the workflow to work?

Paul Newcome

No only the owner.

If I own a sheet and so do you, and we want to set up one of these automations going from one to the other, I need to also be an admin on your sheet, and you need to be an admin on mine.