I have a Google Sheets with two(2) tabs. The first sheet is just a running tally of raw data and is updated with new rows at the top weekly.
In tab 2 there is just a single
query(arrayformula)... that references Sheet1!A2 cell dozen times. The entire formula is 816 characters in length.
Each time I add a single row to tab 1, the formula still works in tab 2 but it now automatically changes all references to Sheet1!A2 to Sheet1!A3 and ignores the inserted row data until manually edited.
Is there a method to avoid manual edit when inserting rows?