# All LookUp formulas & and some informations has gone

**URL:** <https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316>\
**Category:** Report a Bug\
**Created:** [April 18, 2020, 3:54pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316 "2020-04-18T15:54:58Z")\
**Posts on this page:** 1\
**Showing post:** 10

<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:** [April 18, 2020, 6:52pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/10 "2020-04-18T18:52:00Z")

</div>

Here is how to apply the formula in the header row.

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

I use two rows for my head and freeze them both. This allows me to put my headings in row 1 and the formula in row 2.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f46bbf24c41a4c8e085c2f2613f2beb50765318d.png)

---

_[View the full topic](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316)._