# Arrayformula and sheet slowdown **URL:** \ **Category:** Ask for Help\ **Created:** [October 30, 2019, 6:56am UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513 "2019-10-30T06:56:43Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [October 30, 2019, 6:56am UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/1 "2019-10-30T06:56:43Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 30, 2019, 8:24pm UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/2 "2019-10-30T20:24:55Z")
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. ---
**Author:** ![sam1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam1/32/24823_2.png) [@sam1](https://community.glideapps.com/u/sam1)\ **Post date:** [April 22, 2021, 4:25pm UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/3 "2021-04-22T16:25:39Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 22, 2021, 4:32pm UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/4 "2021-04-22T16:32:00Z")
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. ---
**Author:** ![sam1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam1/32/24823_2.png) [@sam1](https://community.glideapps.com/u/sam1)\ **Post date:** [April 23, 2021, 7:25am UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/5 "2021-04-23T07:25:12Z")
oh i see thank you ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 23, 2021, 4:02pm UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/6 "2021-04-23T16:02:52Z")
> [@Darren\_Murphy](#): > > It’s a good general rule of thumb to avoid spreadsheet formulas Well, I’d complement it with …“depending on case!” 😉 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! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 12, 2024, 1:50am UTC](https://community.glideapps.com/t/arrayformula-and-sheet-slowdown/1513/7 "2024-01-12T01:50:02Z")