Hi Thinh,
Does this mean there’s no solution to using Arrayformulae in Glide without exceeding the free allowance as Google Sheets just adds 500 rows by default (which are then filled automatically by the Arrayformulae)?
Also, this seems to happen on only one of my sheets in Google Sheets - all others add only one new row when new data from a form is filled in the Glide app. Could you look at my post / app to see if my issue is solvable in a similar way to this, or if it’s a different issue entirely?
No worries at all. Yes there is quite a complex set of references across a number of sheets so this may be causing the issue. It’s strange though as it wasn’t showing this heavy background calculation before adding the script and turning on iterative calculations - I imagine it’s the iterative calculations that may be to blame.
Anyway, thanks so much for your help!! It’s been immensely helpful! If I can’t solve it I’ll make a separate post as it’s a bit out of scope of the original topic.
