If x Then y Else Do Nothing

[Jeff_Hager]

Arrayformula storage issue

OK, I think I understand this a little better now. I don’t think I realized that your sheet was built from a unique formula. I think the rows are being created by google when the UNIQUE formula hits the end of the sheet and automatically adds the 500 rows as a buffer. I think what we have here is a non-issue. Since your are only building the sheet from a unique formula instead of a from a form button (this is what I thought was happening), you really don’t have to worry about the extra rows …