Sign in to join the conversation:
While I understand the concept behind this change, and I'm not necessarily totally unhappy with it, it is infuriating when the search function will find the sheet on some sheets and not others. I have a destination sheet that has multiple source sheets. What is aggravating is that I'm not sure I've seen a resolution to automate copy rows, if the search function doesn't find the sheet. There has to be an alternative way to build the automated process if/when search doesn't find the destination sheet.
I've tried searching for the workspace name, other sheets in that workspace but to no avail. Then I move to another sheet, and the search function works. I saw a comment somewhere about waiting for a period of time, if the destination sheet is a new sheet. So now, I've waiting an entire weekend and I'm still having the same issue.
I clearly don't understand why it works sometimes and not others. Any insight????
@Linda Hoydic
I have experienced this too and in my example it was down to Ownership of the sheet being searched for. I believe that if the owner of the sheet you are searching for is different to the owner of the sheet you are searching from, then it might not show up on the search (even if you are shared to both as admin)... Could this explain it for you?
(I might be completely wrong here and remembering the wrong reason for the issue, but I do think that I have experienced this reason behind something not showing when I expected it to show) Worth a look anyway!
@Debbie Sawyer I did see a note on the search screen about owner/admin status, and I know that I am either the owner or an admin. I guess I have not paid enough attention to know if there is a difference for those that it finds the destination sheet and those it does not. I guess that could explain, but that is ridiculous as well. I'm am not the owner on all of our sheets in SS, nor do I want or need to be. I am however and admin in all workspaces. I'll try and check that out, but I'm not sure it solves my problem. Thanks !
Hey @Linda Hoydic
To clarify, you don't need to be the owner on any of the sheets, you can be an Admin, that's fine.
However you need the Owner of the current sheet (the one you're taking rows away from) to be shared to the second sheet with at least Admin as well.
Essentially you can't steal rows away from the Owner - they need to be able to access their data in the second sheet, too. Does that make sense?
See the Note in this Help Article:
Cheers,
Genevieve
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
