Move or Copy Rows - Select a destination sheet search tool doesn't respond

JoC

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.

KPH

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.

JoC

KPH - No, the destination sheet is not new. Neither of the sheets are new.

jmyzk_cloudsmart_jp

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".

JoC

jmyzk,

Thank you, after manually moving the row, the destination search tool worked.