Arrayformula on column header

[Valleygirl]

I have a sheet with an ARRAYFORMULA on the column header. But I want to have the formula as an ARRAYFORMULA because when rows are added to my spreadsheet I don’t want to have to require the user to copy/paste a formula.

I’ve used this before, and glide hasn’t stable with ARRAYFORMULAS, I think because the column names are changing. What are best practices with these?

[George_B]

Use this technique:

Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet

I can’t take credit for this tip but I just found out about this trick/tip by reading a post here. So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l…

[Tim_Sullivan]

+1 for @George_B’s method