Move or Copy Rows - Select a destination sheet search tool doesn't respond
![JoC](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to create a move rows automation but the search tool on the "select a destination sheet" window does not respond with results even after typing the entire name of the sheet I want to move the row to. I tried logging out/in, I am the owner of all sheets. The lookup also fails for the copy a row automation.
Answers
-
Is the sheet you want to move the rows to one you have just created? You might need to wait a bit for things to sync up and try again. The new way to select a destination sheet doesn't seem to know new sheets exist for a while after they have been created. I also tried the "switch it off and on again approach" of logging out and in again to no avail. But waiting does work for me.
-
KPH - No, the destination sheet is not new. Neither of the sheets are new.
-
Hi @JoC
The answer to this question may apply to your case as well.😀
https://community.smartsheet.com/discussion/comment/404094#Comment_404094
"The workaround that worked for me is to copy rows manually first. You can use the normal sheet and workspace directory in the manual "Copy to Another Sheet" dialog panel. Then, when you go back to the workflow, you can search the sheet, and it will pop up as candidates."
Another way I often try is to shorten the entire name of the sheet by a couple of characters. For example, if the sheet's name is "Move or Copy Rows", I try the search by "Move or Copy Ro".
-
jmyzk,
Thank you, after manually moving the row, the destination search tool worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!