# Where does Glide insert new entries in a Sheet?

**URL:** <https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467>\
**Category:** Ask for Help\
**Created:** [November 28, 2019, 12:05am UTC](https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467 "2019-11-28T00:05:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SorinAmzu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sorinamzu/32/1820_2.png) [@SorinAmzu](https://community.glideapps.com/u/SorinAmzu)\
**Post date:** [November 28, 2019, 12:05am UTC](https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467/1 "2019-11-28T00:05:26Z")

</div>

Hey all.

Started building a small nutrition app. I’ve been using a Google Sheet for a few months now, but thought it would be awesome to do the data entry on the go via a Glide app.

I was curious where/how Glide adds new entries in a sheet. See example here: [404 File Not Found - Jumpshare](https://jmp.sh/nbnbqG6)  
I want the new entry to be immediately below the previous one. But it seems to jump some rows? I have some VLOOKUP formulas that I want to interact with my data entry. But it seems Glide adds a new entry ONLY if it finds a completely blank row? Or…?

Would appreciate your input.

Thank you!

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [November 28, 2019, 12:09am UTC](https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467/2 "2019-11-28T00:09:58Z")

</div>

See the note about this in our documentation: [https://docs.glideapps.com/all/guides/quick-starts/getting-started/adding-items](https://docs.glideapps.com/all/guides/quick-starts/getting-started/adding-items)

(New rows add after any other content)

---

<div class="post-metadata">

**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:** [November 28, 2019, 1:06am UTC](https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467/3 "2019-11-28T01:06:44Z")

</div>

If you are not using arrayformulas, I suggest you should. Also be sure to delete any empty rows.

[https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/calculating-columns](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/calculating-columns)

---

<div class="post-metadata">

**Author:** ![SorinAmzu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sorinamzu/32/1820_2.png) [@SorinAmzu](https://community.glideapps.com/u/SorinAmzu)\
**Post date:** [November 28, 2019, 6:37am UTC](https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467/4 "2019-11-28T06:37:18Z")

</div>

The arrayformulas seems like what I need. Would Glide understand that applied arrayformulas do not actually count as filled row? So that when I add a new item, it would automatically calculate what I need via the array formula?

Thank you.

---

<div class="post-metadata">

**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:** [November 28, 2019, 1:00pm UTC](https://community.glideapps.com/t/where-does-glide-insert-new-entries-in-a-sheet/2467/5 "2019-11-28T13:00:40Z")

</div>

Rows with an arrayformula applied are still recognized as filled rows. That’s why I recommend deleting all empty rows, otherwise new data is added after the last row in the sheet.  
A new row of data from Glide will create a new row in the sheet and the arrayformula will automatically apply to the newly created row.