Move Rows Automation - I can't find the sheet I want to move all of my rows to?!
Hi All,
I have a Smartsheet which contains client quotations. I want to build an automation that will move expired quotes out to a 'Cold Leads' Sheet so the main sheet just contains confirmed quotes.
I want to target the automation so a checkbox is selected by the user, when that checkbox is checked, it will move the row out to the Cold Sheet for follow up at a later date.
I have created an exact copy of the original sheet so that all of the data moves across correctly, however when mapping - Smartsheet doesn't give me the option to move rows to the sheet I've just created. Infact, the choice of sheets I can move to are very limited and not anything like the amount of sheets/workspaces I have created/am shared to.
Any help would be hugely appreciated!
Best Answers
-
@mwood At the risk of being obvious:
- does the target sheet have a unique name? (it would be awkward if it had exactly the same name as your source).
- have you tried typing the first characters of your target sheet in that "Type here ..." box? That should force SmartSheet to search all sheets you are admin on.
- and this:
Cheers,
Dale
-
Hi @mwood
Is the owner of the Master Sheet shared to the target sheet at all?
You won't need ownership of the Master Sheet, but the current owner also needs to have access to the Target with Admin permissions (essentially you can't steal rows away from the owner).
The "Select a Sheet" window will only show you sheets where the current owner of this Master Sheet is shared with Admin or Owner permissions.
Let me know if this makes sense or if I can clarify anything further!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi Genevieve,
That's worked perfectly. The owner of the other sheet was only an Editor on the newly created sheet. I've upped the user to Admin and the automation is now working.
Thank you!
Matt
Answers
-
@mwood At the risk of being obvious:
- does the target sheet have a unique name? (it would be awkward if it had exactly the same name as your source).
- have you tried typing the first characters of your target sheet in that "Type here ..." box? That should force SmartSheet to search all sheets you are admin on.
- and this:
Cheers,
Dale
-
Hi Dale,
I've tried the first two but strangely, there were very limited sheets for me to be able to move the rows out to. Certainly less than I have Admin/Ownership rights on.
I'm the owner of the target sheet, but only an admin on the master sheet I need the rows to copy from. I have requested ownership on the main sheet so I am an owner on both sheets to see if this does the trick. I will report back once I have an update.
Thank you so much for your response.
Matt
-
Hi @mwood
Is the owner of the Master Sheet shared to the target sheet at all?
You won't need ownership of the Master Sheet, but the current owner also needs to have access to the Target with Admin permissions (essentially you can't steal rows away from the owner).
The "Select a Sheet" window will only show you sheets where the current owner of this Master Sheet is shared with Admin or Owner permissions.
Let me know if this makes sense or if I can clarify anything further!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi Genevieve,
That's worked perfectly. The owner of the other sheet was only an Editor on the newly created sheet. I've upped the user to Admin and the automation is now working.
Thank you!
Matt
-
Hi @mwood
No problem, I'm glad we figured it out! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!