Why does my target sheet not show in search?

I'm trying to copy a row from an original sheet to a destination sheet. However, when I try to select the destination sheet, the search returns no sheets:

Screenshot 2024-07-11 at 13.32.46.png

I saw that both the original sheet and the destination sheet must be shared with Admin/Owner status. This is the original sheet:

Screenshot 2024-07-11 at 13.33.07.png

And this is the destination sheet:

Screenshot 2024-07-11 at 13.33.20.png

Why am I not able to select the destination sheet?

Best Answer

Answers