I recently discovered in my client’s expense tracking app that there were a number of blank records in the Expenses sheet, with the exception of two columns containing ArrayFormula logic returning a value of “False”.
I first began by deleting the individual records 1 and 2 records at a time. I then discovered that Google Sheets had somehow inserted 999 blank rows into the sheet. I had read where deleting large numbers of rows can cause problems for Google Sheets with Glide.
I went back and reworked the ArrayFormulae causing the return of FALSE as follows:
This formula returned a value of FALSE if the cell in column A was blank.
This eliminated the FALSE values from the two columns that were causing the problem.
My question is what is the safest way to get rid of the 999 blank rows?
This is a live app being used by a client. I don’t want to cause a problem.
Thanks for any insights.