Dear Gliders, 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…

Having Data saved way down the bottom is a classic beginner’s mistake! I vaguely remember it was my first time using =arrayformula things. My glide app would write a new row in, but it would appear way way down. Good luck!!

If you try to delete those empty rows after your last row of real data, and then they reappear instantly, it means you have a formula working wrong in a column! I’ve had this before! I copied all my columns that could be at fault I to another sheet. Then I deleted the blank rows from my main sheet…

Thanks Mark. The thing is there is data after the 999 blank rows. I don’t know what caused the blank rows to be added. I will take your suggestion and copy the entire worksheet to another file, delete the two columns that were the original culprits and reintroduce them after deleting blank rows.

It worked. I copied the two ArrayFormula columns to a separate sheet and deleted all blank rows. Then re-entered the ArrayFormulae in both columns and it’s all nice and tight with no blanks. Thanks again!

Also, a good practice is to store arrayformulas in the header so you don’t accidentally delete them. I covered that part in this post, hope it helps. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for He…

[image] Getting rid of excess rows and/or columns (the easy way) Ask for Help Anyone that’s been using Glide for a while will know that it’s generally a good practice to remove excess rows from the bottom of your Google Sheets. But doing so manually can be a bit tedious. …

@ThinhDinh totally agree. I did not do this at first, putting my arrayformulas into Row 2… but eventually you run into problems. Now I know how to put the column heading into my formula, everything is running wonderfully well! I have also got into =QUERY (thanks to you again!) which helps to merge …

[image] Mark_Turrell: And every once in a while there is a g-formula that does not work in a standard way with =arrayformula Here is a scripting solution for functions that don’t work with ARRAYFORMULA… [image] Scripts, scripts, scripts! Ask for Help Here is anothe…

Deleting Google Sheets Records

Ask for Help

Darren_Murphy March 25, 2021, 12:48am 7

I use the above script on most of my Google Sheets.

Topic		Replies	Views
Delete rows action-problems with arrayformula gsheets Report a Bug	8	149	April 26, 2025
Google Sheets and ARRAYFORMULA Ask for Help	22	2941	July 13, 2023
Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet Project Showcase	6	4598	August 8, 2020
ADD with ARRAYFORMULA? Ask for Help	9	390	April 29, 2020
Why is there a gap of blank rows of my Google Sheet? Ask for Help	2	264	November 8, 2021

Deleting Google Sheets Records

Related topics