nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

cannot delete ref links from vlookup

simon_z

Hi I tested vlookup function and I created a new sheet .I deleted this new sheet but now in my master sheet it's still outbound to ref unknown sheet. I cannot delete that link...

Find more posts tagged with

Cell linking

Comments

Daniel Stein

Hi Simon,

Cross-sheet references are automatically deleted after 2 hours, once they are no longer being used. This is to prevent references from being cleaned up while users are in the midst of editing their formulas.

There is a known issue for which we will roll out a fix shortly where the arrows don't go away if you deleted the destination sheet. In the meantime, I'd recommend that you go to Home --> Deleted Items and undelete your sheet. Then, delete all cross-sheet formulas on the sheet and Save. After 2 hours, if you edit either of the sheets, then the arrows will go away. Feel free to contact our support team if you need any assistance with this: https://help.smartsheet.com/contact

Once the fix rolls out (in the next day or so), arrows will also go away as expected when you delete the destination sheet.

In the next month or so, we also plan to add a "delete" control to the source sheet so that customers can delete the links manually without waiting for the 2 hour cleanup or deleting the destination sheet.

Hope this helps, and apologies for the inconvenience!

Best regards,

Daniel

simon_z

Hi thank you. I sadly empty the trash so no recovered sheet. I guess I,'ll wait for the fix on your side.

simon_z

Any news on this, is the fix happening?

Thanks

simon_z

it's fix thank you

Sign in to join the conversation!

Quick Links

Trending discussions

The intermediary sheet not updating with the source
Hello, I have a destination sheet that is cell linked to a source sheet. The source sheet is constantly being updated (adding information, deleting information) but the destination sheet does not reflect those updates. Is there any work around this issue? Any way that the destination sheet reflects the updates real time? I…
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt
I am geting this erer
i got this error while working , when i close it it pops up again, i even restarted the app but no use. this happened last week to but it stoppedthe next day. can summon help . Update : it now stopped, after restarting it again and popping up again it stopped.What is triggering this error .