Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Remove Outbound Links to Unknown sheet?

Matt Cochran
edited 12/09/19 in Archived 2015 Posts

Hi,  i changed some sheets around in a workspace and ended up with a bunch of outbound links to unknown pages.

 

is there a way to remove all outbound links to unknown?  or am i stuck going one cell at a time and deleting?

 

thanks 

Tags:

Comments

  • Hi Matt - 

     

    If the target sheet was deleted, you could undelete the sheet (click Home > Deleted Items, right-click the sheet to Undelete) and then bulk remove the links from the target sheet. To bulk remove the links, multi-select the cells (hold Ctrl on a PC or command on a Mac and then click the cells), right-click the selection, and click Remove Link. 

     

    If you run into any troubles with this, feel free to reach out to our Support team at support@smartsheet.com. 

     

    Thanks,

    Sonia

  • Hi, I have a LOT of cells that have these <unknown link> in them in a single spreadsheet, and its going to be very tedious to remove all of them one at a time. I dont know the name of the original file they were linked to, and just want to globally remove them all. Is there a way to do that?

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 07/18/17

    Craig,

    Please post an enhancement request here:

    https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409

    These older posts are likely unmonitored. The Community Managers get promoted and/or move on and whether anyone at Smartsheet catches an update seems to be hit or miss.

    Smartsheet has made a small improvement here. If the source sheet is deleted, the Link In arrow is now red. A valid Link In will be blue.

    You can select multiple cells at once and remove the inbound links using the right-click menu, but there is not (yet) a "remove only invalid links" option. That means when you remove the links in a range, all of the inbound links are removed (outbound links are not removed).

    There is no way in the GUI to remove all invalid links in one or more sheets.

    Craig

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    See my comment here:

    https://community.smartsheet.com/comment/60261

    There is now a way to delete the <unknown sheet> references.

    Craig

This discussion has been closed.