I have a sort of summary in my Google 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?
The link to the Google sheet is: Link