# Google Sheets Formula Carry Down

**URL:** <https://community.glideapps.com/t/google-sheets-formula-carry-down/20546>\
**Category:** Ask for Help\
**Created:** [December 31, 2020, 3:45pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546 "2020-12-31T15:45:21Z")\
**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:** [December 31, 2020, 4:12pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/2 "2020-12-31T16:12:24Z")

</div>

I would recommend learning about arrayformulas. But if possible, my higher recommendation would be to attempt to built the logic using glide columns in the data editor. It much easier and the app responds much faster than waiting for data to sync to the sheet, update with a formula, then sync back to the app. Glide columns update instantly on the user’s device.

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

---

_[View the full topic](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546)._
