In order to extend formulas to whole columns within Google Sheets, it is recommended to use the useful function ARRAYFORMULA, which unfortunately does not work in combination with some other important functions like QUERY or INDIRECT, which leaves a complete individual programming of the logic using Google Apps Script or alternatively copying the formula manually down to the last line.
As an alternative for the second option, we'll create a small helper function that searches for formulas in row 2 of all worksheets and automatically copies them to the end of the worksheets. ARRAYFORMULA formulas are automatically ignored. This function can be added via Tools > Script Editor and scheduled to run once per minute using Edit > Trigger for the current project.:
f9c221988a2b56958ffb5b0649bbdf27