I know ARRAYFORMULA is out of favor at the moment, and that’s great. Because it seems to me there’s a fundamental problem with it: namely, the ARRAYFORMULA itself exists in a row of your data. If that row gets deleted, your ARRAYFORMULA is gone. (I’ve tried it.) Have I missed something? Because, if…

I laughed out loud at the “Header” thing because I was trying to figure out a trick like that earlier. Nice one! In the second example, wouldn’t you end up with a blank row in your data? For some apps not a problem, I image. But still. Thanks!

Yeah, I agree with that. But it’s clear from the online discussions that people still use it. I’ve been staying away from it myself, although once in a while I’m certainly tempted. :smiling_imp:

Jeff, I haven’t used arrayformula in ages. Any reason why you use isblank ARRAYFORMULA(IF(ISBLANK(A2:A) in one case and len=0 ARRAYFORMULA(IF(LEN(A2:A)=0 in the other?

Good to know! I was just wondering that.

Hehe, I did a quick search in the forum to find examples. No particular reason other than those are the two examples I found.

[image] nathanaelb: New used don’t necessarily understand how arrayformula is interpreted by Glide: that cells populated by arrayformula may appear blank in GS but in fact are not blank at all. Data added to sheet therefore is added at the bottom and that confuses a lot of new Glide developers. …

[image] escott: Because, if not, every ARRAYFORMULA is a bug waiting to happen. (Yes, you can work around this in various ugly ways, that IMHO are also bugs waiting to happen.) Absolutely agree with that, and have been bitten by it in the past. I have older projects that still have the odd a…

The doc needs to catch up with current practice. ARRAYFORMULA is still there, with no warning about this issue or, IIRC, any other.

yeah, for sure. That whole section on Spreadsheet Tips is really outdated. There is a big effort going on at the moment to update the Glide Docs, but I don’t believe this section has been touched yet.

Google Sheets and ARRAYFORMULA

Ask for Help

Darren_Murphy July 13, 2023, 4:19pm 23

Of course there is

Topic		Replies	Views
Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet Project Showcase	6	4587	August 8, 2020
If user deletes 1st row, he loses array formula Ask for Help	9	2417	December 9, 2020
Problems with Arrayformula Report a Bug	1	663	October 26, 2019
Deleting Google Sheets Records Ask for Help	8	1871	March 25, 2021
Add new row is clearing my Google Sheet formula Ask for Help	5	812	September 3, 2021

Google Sheets and ARRAYFORMULA

Related topics