# Newly added rows do not extend formula columns, leaving some calculated columns empty

**URL:** <https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418>\
**Category:** Ask for Help\
**Created:** [September 19, 2019, 7:40pm UTC](https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418 "2019-09-19T19:40:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\
**Post date:** [September 19, 2019, 7:40pm UTC](https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418/1 "2019-09-19T19:40:25Z")

</div>

When a new value is added using the icon, lines containing formulas or functions are not written data, but a new line is created at the end of the worksheet.

My app’s URL: [https://go.glideapps.com/play/xEresFO3nbR7mDEAhF8G](https://go.glideapps.com/play/xEresFO3nbR7mDEAhF8G)

---

<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:** [September 19, 2019, 8:26pm UTC](https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418/2 "2019-09-19T20:26:32Z")

</div>

This is not an error, this is how spreadsheets work, sadly.

Here’s what to do about it: [https://docs.glideapps.com/all/guides/intermediate-techniques/calculating-columns](https://docs.glideapps.com/all/guides/intermediate-techniques/calculating-columns)

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 19, 2019, 9:24pm UTC](https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418/3 "2019-09-19T21:24:18Z")

</div>

@Alex_Calandrino One thing I would suggest to add to the tutorial that @david linked to is that you should delete all empty rows on any sheet that you use array formulas on. The reason for this is not needed for Glide, as it does ignore empty rows. It is good practice so you don’t have to scroll all the way down to row 1001 to see the latest row that was added. Because of the arrayformula the sheet thinks it has data all the way to the last physical row of the sheet, not the last row of data. This will save you a lot of head scratching when you are wondering why you can’t see what was just added.

---

<div class="post-metadata">

**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\
**Post date:** [September 20, 2019, 4:56am UTC](https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418/4 "2019-09-20T04:56:17Z")

</div>

I managed to solve, thank you very much for helping