# Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

**URL:** <https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727>\
**Category:** Ask for Help\
**Created:** [May 25, 2020, 1:10pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727 "2020-05-25T13:10:24Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 25, 2020, 1:13pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/2 "2020-05-25T13:13:54Z")

</div>

This post was inspired by:

- A discussion with @nathanaelb when he solved a problem by the sequence function.

> [@Group by to filter data](https://community.glideapps.com/t/group-by-to-filter-data/9467/14):
>
> You can wrap arrayformula() around sequence() to create decimal numbers within the sequence, since the sequence() function does not allow decimal counts: [image] What I don’t know how to do is pull sequence() down the column. man_shrugging

- A time when I helped @Robert_Petitto when his arrayformula just works with the first row and it populates the other rows with the same information.

 ![Screen Shot 2020-05-13 at 10.33.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dcb38a22ad6738396d5df401537f1e25d3e82255.png)

---

_[View the full topic](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727)._