# Problems with Arrayformula

**URL:** <https://community.glideapps.com/t/problems-with-arrayformula/1408>\
**Category:** Report a Bug\
**Created:** [October 26, 2019, 3:04pm UTC](https://community.glideapps.com/t/problems-with-arrayformula/1408 "2019-10-26T15:04:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicolas\_Meharry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicolas_meharry/32/1134_2.png) [@Nicolas\_Meharry](https://community.glideapps.com/u/Nicolas_Meharry)\
**Post date:** [October 26, 2019, 3:04pm UTC](https://community.glideapps.com/t/problems-with-arrayformula/1408/1 "2019-10-26T15:04:43Z")

</div>

Hi everyone !  
I’m posting for my first time here because I’m having issues with ArrayFormula.  
When I want to create a new profil from my glide project, the profil adds itself on the google sheet but under the last row where the formula apply.  
In the photos you can see that I’m using a arrayformula from the 2nd to the 12th row to add an “e” at 1e, 2e etc. (1st, 2nd in french) for a ranking.  
So each time I want to create a new profil in my glideapp, the formula doesn’t apply. Do you have a solution for this ?  
I hope to have been clear.  
Thank’s.!

 ![Slack4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1b898f74f25241e333df7eee31b1f7ad8c63ee93.png)

---

<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:** [October 26, 2019, 3:34pm UTC](https://community.glideapps.com/t/problems-with-arrayformula/1408/2 "2019-10-26T15:34:31Z")

</div>

Row’s with formulas are considered filled rows. Glide looks for the first empty row to add new data. Because of that, it is advised to use arrayformulas instead to autopopulate the formula down and then delete all of the empty rows. When a new row is added from the app, then it will add the row to the sheet and apply the formula to the new row. Here is some additional information.

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

> [@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…