I have a worksheet with about 60,000 rows of data with about 100 columns. I've named the data "Raw_Data". To the right of this data I have a large number of columns with formulas.

I'm well familiar with inserting columns and having the cell references in the formulas adjusted automatically. But, I have a large number of formulas similar to:

=SORT(FILTER(INDEX(Raw_Data,SEQUENCE(ROWS(Raw_Data)),{4,2,30,31,32,19,20}),((criteria1)*(criteria2)),"No Results"),7,-1)

I rarely but recently had to insert some new columns in the Raw_Data section of the worksheet. The vast majority of the formulas on the sheet adjusted normally. But, the formulas similar to above did not adjust the columns to return (the {4,2,30,31,32,19,20} part ). I had to find over a hundred of these formulas and change the column numbers. It was very time consuming.

Is this normal? Is there something I could do to make any future inserting less of a problem?