No options for selection of destination sheet to copy rows with automation
Trying to copy rows across sheets across workspaces (both of which I own) but when I go to select destination sheet nothing show up, blank screen.
Any thoughts on what I may be missing here?
Thanks in advance
Answers
-
Hope you are fine, did you try to copy the row by using workflow or by using direct order in the Row dropdown menu?
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam, I can copy the over fine directly from the row - when I try to do via a workflow is when I am running into this issue.
THanks!
-
Same exact issue here!
-
I had this problem today, and finally figured out what was going on!
Both you and the Owner of the source sheet must have Owner or Admin privileges on the destination sheet. Makes sense - that way the source sheet Owner doesn't lose access to data that's moved.
If the screen is blank when you go to select the destination sheet, it's likely because you and the sheet Owner don't both have Owner/Admin access to any other sheets.
-
I am having the same issue. I am admin on the source sheet and owner on destination sheet. However, the destination sheet does not appear in my drop down list of available sheets. Can anyone tell me why?
-
Is the current owner of your first sheet shared as an Admin on your second sheet?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
No, I am admin on the source sheet and owner of destination sheet, which is currently not shared.
-
Thanks for clarifying! The reason your second sheet isn't showing up as an option is because the current owner isn't shared on it.
Both you and the owner need to be on the destination sheet. Here's the Help Article with more information: Automatically move or copy rows between sheets
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
That worked! I didn't know the destination needed the same admin. Thanks!
-
Thanks for the help on these, I was having the same issue and this helped resolve.
-
Hi
I am really struggling with this.
I am the owner of both of my sheets and have used this function many times, but now I can't see the destination sheet options.
Many thanks
-
Hi @Greg Howell
The sheet picker for Copy or Move row workflow actions has been updated; instead of seeing a list of all your current sheets, you'll need to use the Search bar to enter a keyword or full name of the sheet you're looking for in order to have it appear.
Let me know if you're still having trouble after entering the full sheet name + clicking "enter"!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. thanks for getting back to me.
I worked it out and am up and running again.
Appreciate you taking the time.
Cheers
-
I'm trying to set up the same workflow for several different destinations. I'm the owner on all sheets, and I was able to get this set up earlier today. Right now, I'm not able to find ANY destination sheets.
-
Hello, Has this been resolved - I'm the owner of both sheets and no sheets are showing while trying to do a search for a destination sheet. Thx! Disregard - I figured it out :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!