Is it possible to remove all "unknown sheet" links from a sheet?

System

This discussion was created from comments split from: Website report shows Link out to: <unknown sheet>.

THUNT6

Wanted to check to see if there was a way to bulk remove the <unknown sheet> links from a sheet? I can remove the link one cell at a time but I have thousands of cells with this link (trying to fix slow saving / uploading problems)

kowal

hi @THUNT6 ,

whata about a workflow that will move the rows to another sheet and once it's moved to the destination sheet you will just delete it?

it would move all the rows with <unknown sheet> at once.

hope it helps.

THUNT6

Doesn't help. I need to keep the rows where they are and the <unknown sheet> reference is in multiple columns. Can't find the referring sheet to restore and remove the reference.

kowal

sorry I could not help.

Jessica Miller

@THUNT6 If you highlight all the rows (by dragging across cells, not by selecting at row or column level) and then right click, you'll get 'Manage References' in the dropdown.
You can select all/many from there.
Does that meet your needs?

Screenshot 2025-03-20 101800.png

Andrée Starå

https://community.smartsheet.com/discussion/comment/477158#Comment_477158

Hi,

I hope you're well and safe!

As far as I know, there isn't. Also, remember that they usually show that way when you don't have access to that sheet, so you don't break anything.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!