Arrayformula and sheet slowdown

Ask for Help
1

Ever since I got somewhat comfortable with Arrayformula I have been using it everywhere and can’t imagine how I survived without it for so long.

My question is if it affects the performance of the spreadsheet that much. My calculations would be simple, limited to COUNTIFS, SUMIFS, IF conditions based on multiple columns etc.

Would appreciate some advice on how much is too much.

2

Simple formulas seem to run pretty quickly, so as long as the sheet is updating quickly, I would think you would be fine. I use several formulas and queries and I haven’t noticed any lag. I’m not working with massive data sets, but I’m also running some scripts and and haven’t run into any speed issues yet.

3

Hello,
I have a quantity column, a price column & a subtotal column. I used array formula in subtotal column to multiply quantity & price.It works when price is written as 10 but not when it is $10.

4

I would advise doing simple calculations like these in Glide instead of in the spreadsheet.

It’s a good general rule of thumb to avoid spreadsheet formulas wherever possible.

4 Likes
5

oh i see thank you

6

Well, I’d complement it with …“depending on case!” :wink:

E.g. You have 8-10.000 records (rows) associated to sales/prices and your goal is to calc and show Sales stats: Total Sales, Total Invoices (count), Max/Mix Sales or have a Top 10 list, why do I have to load all this data to APP if…

  • That data isn’t urgent to most users?
  • You are going to need or see it few times. Maybe twice per hour is enough?
  • The stats will only consume 12-15 rows in GS vs. 8-10k rows in APP?

If your APP can be lighter avoiding useless data so, create useful data in your GS using formulas. It is valid and great resource to help Glide.

Saludos!

3 Likes