# Why are so many lines inserted?

**URL:** <https://community.glideapps.com/t/why-are-so-many-lines-inserted/3303>\
**Category:** Ask for Help\
**Created:** [January 3, 2020, 4:21pm UTC](https://community.glideapps.com/t/why-are-so-many-lines-inserted/3303 "2020-01-03T16:21:54Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**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:** [January 3, 2020, 4:38pm UTC](https://community.glideapps.com/t/why-are-so-many-lines-inserted/3303/2 "2020-01-03T16:38:18Z")

</div>

You will have to delete all the empty rows in the sheet if you use ARRAYFORMULA in a form. The reason is that the cells that are calculated by ARRAYFORMULA are considered non-empty by Glide, and hence the next row is inserted only after whatever rows are present in the sheet already.

Ref: Check the “Edit” note in the first post in the thread below.

> [@Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet](https://community.glideapps.com/t/using-arrayformula-s-in-row-1-of-your-spreadsheet/529):
>
> I can’t take credit for this tip but I just found out about this trick/tip by reading a post [here](https://community.glideapps.com/t/if-user-deletes-1st-row-he-loses-array-formula/246). So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l…

---

_[View the full topic](https://community.glideapps.com/t/why-are-so-many-lines-inserted/3303)._
