Earlier I asked this question: How to create a link with content bound to other cell's content in Google sheets?
And until now the provided solution was working perfectly for me but now, the problem is: I just realized that whenever I insert/delete a row/column from my referenced sheet the links generated using the aforementioned question's answer will become broken and will link to an other cell/range.
Here's an example to reproduce:
- On a first sheet, fill A1 with some text
- On a second sheet, create a link to A1 (using the aforementioned question's answer)
- Use the link to come back to the first sheet, you should have your cell with text selected
- Insert a row above row 1
- Come back to second sheet and try to use the link again : it now selected an empty cell on row one instead of selecting the cell with your text
How can I overcome this problem and have "stable" links that always send me to the same cell using its "reference" and not its location?