# Arrayformula on column header

**URL:** https://community.glideapps.com/t/arrayformula-on-column-header/4728
**Category:** Ask for Help
**Created:** [February 18, 2020, 10:11pm UTC](https://community.glideapps.com/t/arrayformula-on-column-header/4728 "2020-02-18T22:11:21Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Valleygirl](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valleygirl/32/2514_2.png) [@Valleygirl](https://community.glideapps.com/u/Valleygirl)
#### Post date: [February 18, 2020, 10:11pm UTC](https://community.glideapps.com/t/arrayformula-on-column-header/4728/1 "2020-02-18T22:11:21Z")

</div>

I have a sheet with an ARRAYFORMULA on the column header. But I want to have the formula as an ARRAYFORMULA because when rows are added to my spreadsheet I don’t want to have to require the user to copy/paste a formula.

I’ve used this before, and glide hasn’t stable with ARRAYFORMULAS, I think because the column names are changing. What are best practices with these?

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [February 18, 2020, 10:26pm UTC](https://community.glideapps.com/t/arrayformula-on-column-header/4728/2 "2020-02-18T22:26:50Z")

</div>

Use this technique:

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

---

<div class="post-metadata">

### Author: ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [February 18, 2020, 11:25pm UTC](https://community.glideapps.com/t/arrayformula-on-column-header/4728/3 "2020-02-18T23:25:17Z")

</div>

+1 for @George_B’s method