# Array Formula creating more rows than it should **URL:** \ **Category:** Ask for Help\ **Created:** [October 26, 2020, 1:16am UTC](https://community.glideapps.com/t/array-formula-creating-more-rows-than-it-should/17595 "2020-10-26T01:16:06Z")\ **Posts on this page:** 1\ **Showing post:** 12
**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 26, 2020, 1:03pm UTC](https://community.glideapps.com/t/array-formula-creating-more-rows-than-it-should/17595/12 "2020-10-26T13:03:30Z")
When using arrayformulas, you will always have to delete the empty rows. Glide won’t seem them now that they are blank, but if you add new rows through the app, they will be placed at the bottom of the sheet. Here’s a tutorial on it’s use: > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … And just my suggestion, unless you have a specific reason for performing the formula in the sheet…you could easily duplicate this same thing with a Relation and Lookup in the Glide data editor. It would be much faster as you wouldn’t have to wait for formulas to run in the sheet, which causes delays. --- _[View the full topic](https://community.glideapps.com/t/array-formula-creating-more-rows-than-it-should/17595)._