How can I copy a row from sheet with cell links to antoher sheet? Reccuring workflow not working
Hi all,
I am trying to COPY rows automatically when a project owner name is changed from the original sheet to a destination sheet. The original sheet has cross links to another sheet and hence, I tried to use recurring workflows. Neverthless, not able to find the desitination sheet in the search box. I have tried to write the name of the sheet, copy link, pressed enter etc. but nothing seems to move the rows. Please help!
Best Answer
-
Hi @Ishuvenkat,
It sounds like you might be an Admin on the source sheet and the Owner of the destination sheet, and the Owner of the source sheet isn’t shared to the destination sheet. The Owner of the source sheet must have Admin permissions on the destination sheet. Check out Genevieve’s full explanation of this in this comment!
Hope that resolves it!
Georgie
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hello,
It happened to me before. If you cant find the destination sheet make sure it's saved.
Refresh this sheet few times and the destination sheet should appear after few seconds.
Let me know if it helps but for me it was always just a matter of time.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Hi @Ishuvenkat,
To add to the above, it might be that the destination sheet was newly created in a different browser tab or window, and the browser tab/window on which you’re attempting to create the workflow hasn’t updated to “see” that sheet yet. If the destination sheet was recently created, try refreshing your browser tab/window and the destination sheet should then appear in the sheet selector when you type in the name.
Another potential cause is if the relevant users don’t have the correct permissions on the source and destination sheet - both the sheet Owner and the workflow creator need to have Owner or Admin permissions on both the source and destination sheets to create an automated copy rows action. That is, if you, as the workflow creator, are an Admin on the source sheet, the Owner of that sheet will need to have Admin or Owner permissions on the destination sheet too. See this article for more information on copy rows workflows: Work with the copy rows action.
If you’ve confirmed you (and the sheet Owner if that’s not you) have the correct permissions on the source and destination sheets,
Hope that helps!
Georgie
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi both,
I have saved the sheet, refreshed browser, opened the next day in a new browser, and I am an Owner / Admin for both sheets. I still do not see the destination and I am thinking it is because of cross links in the source sheet. The work around for this was use recurring workflows, but that also is not working.
-
Hi @Ishuvenkat,
It sounds like you might be an Admin on the source sheet and the Owner of the destination sheet, and the Owner of the source sheet isn’t shared to the destination sheet. The Owner of the source sheet must have Admin permissions on the destination sheet. Check out Genevieve’s full explanation of this in this comment!
Hope that resolves it!
Georgie
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Oh wow, that worked. I made myself the owner on both. I did not know the owner needs to be an admin in the destination sheet. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives