# Sheet formula is not working on newly created row **URL:** \ **Category:** Ask for Help\ **Created:** [May 28, 2020, 5:31pm UTC](https://community.glideapps.com/t/sheet-formula-is-not-working-on-newly-created-row/9941 "2020-05-28T17:31:59Z")\ **Posts on this page:** 1\ **Showing post:** 4
**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:** [May 28, 2020, 6:22pm UTC](https://community.glideapps.com/t/sheet-formula-is-not-working-on-newly-created-row/9941/4 "2020-05-28T18:22:07Z")
Here’s an excellent write-up on arrayformula usage. Glide will not write data in a row that’s occupied with a formula. It looks for an empty row. When using arrayformulas, you write the formula once and it populates all rows. You just need to make sure you delete all empty rows, otherwise new data from Glide will be written to a new row at the bottom in the sheet. > [@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 … --- _[View the full topic](https://community.glideapps.com/t/sheet-formula-is-not-working-on-newly-created-row/9941)._