"Clearing" contents of a cell

[George_B]

Put your arrayformula in row 1. See this post. Also it’s not really a good idea to have those arrayformula’s in those rows in your reports sheet column B. You don’t need them anyway if you just expand the range of the one you currently have in row 2.

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…