# How do you add functions to rows you add with glide?

**URL:** <https://community.glideapps.com/t/how-do-you-add-functions-to-rows-you-add-with-glide/16740>\
**Category:** Ask for Help\
**Created:** [October 4, 2020, 7:52pm UTC](https://community.glideapps.com/t/how-do-you-add-functions-to-rows-you-add-with-glide/16740 "2020-10-04T19:52:27Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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 4, 2020, 8:07pm UTC](https://community.glideapps.com/t/how-do-you-add-functions-to-rows-you-add-with-glide/16740/2 "2020-10-04T20:07:40Z")

</div>

Arrayformula’s are best, but google will interpret a row that has a formula as a filled row and look for the next empty row to add data. That’s why dragging a formula never works. When using an arrayformula, it’s best to put in an IF statement to only use the formula when another column is populated, else return a blank value. Otherwise it will put something in the cell and glide will interpret it as a filled row. Also it’s best to delete all empty rows because the nature of arrayformulas fills every row in the sheet, regardless if you see anything in the cell or now. Otherwise google creates a new row and appends to the bottom of the sheet.

Here is a tutorial on using arrayformulas.

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

Glide does not interpret sheet formulas and will just treat it like text. However, keep in mind that depending on what you are trying to achieve, you can do a lot of functions within glide using math, rollup, if/then, etc. columns in the glide data editor.

---

_[View the full topic](https://community.glideapps.com/t/how-do-you-add-functions-to-rows-you-add-with-glide/16740)._