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:

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

Updated May 25, 2018 15:03 PM

Updated December 03, 2018 06:03 AM

Updated March 09, 2019 18:03 PM

Updated May 09, 2019 17:03 PM