Google Drive: problem inserting a column and cell reference/link

by Michel Keijzers   Last Updated April 15, 2019 11:03 AM

I have a sort of summary in my google drive/ sheet. In the second column, I refer to the sub tables further in the sheet with e.g. this content:

https://docs.google.com/spreadsheets/d/1J-
lBYHVVGjX1e8e_ZpeiNJIywJxfSW9waliWbJ2ICmM/edit#gid=0&range=f1

Meaning it refers to column F1.

This works fine; when clicking on the cell in the summary the focus is moved to column F1.

However, when I insert columns before the F column, the link is not changed and thus the column is referring to the wrong column.

Is there a better way to handle this?



Related Questions



How to reference a Google Sheet by filename?

Updated December 03, 2018 06:03 AM

Conditional Formatting Duplicate Invoices in Excel

Updated March 09, 2019 18:03 PM

Multiple conversions in one cell

Updated April 27, 2018 09:03 AM