Google Sheets: Expanding Formulas

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, we build a small auxiliary function for the second variant that searches for formulas in line 2 of all worksheets and automatically copies them to the end of the tables. ARRAYFORMULA formulas are automatically ignored. You insert the whole thing via Tools> Script Editor and let it run time-controlled 1x per minute via Edit> Trigger of the current project: