Link Cells Then Delete Rows

DieHard Jets

It seems like when I have a row linked to my "master" sheet, and then I learn I don't need that row after all, the links to my rows below the row I deleted no longer match what they were previously linked to.

And vice versa, when I delete a row in the master sheet, it seems to throw the linked rows in the destination sheet off.

Isn't there a way to "freeze" the links even when rows get deleted in the master or destination sheet?

Carson Penticuff

See this article on Cell Linking. If rows or cells above the linked cell are deleted, the link stays intact.

https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linking#:~:text=Open%20the%20destination%20sheet.,to%20search%20for%20the%20sheet.