# All LookUp formulas & and some informations has gone **URL:** \ **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:** 10\ **Page:** 1
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 18, 2020, 3:54pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/1 "2020-04-18T15:54:58Z")
My app’s URL: [premiereaquecedores.glideapp.io](http://premiereaquecedores.glideapp.io) Sheet: **Orçamentos** **PLEASE DO NOT LOGIN IN THIS APP** In this same app my formulas (All that columns that contains `"Valor..."` I use lookup formula) and the informations that I use choice column in glide (all columns that contains `"Serviço.."; "Serviço Adicional" ; or "Produto.."`). I dont know what to do, 'cause my client has complained every day 😭 ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [April 18, 2020, 4:11pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/2 "2020-04-18T16:11:38Z")
Can you please make a video explaining the problem and showing it to us? Really can’t understand from your description. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 18, 2020, 4:16pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/3 "2020-04-18T16:16:40Z")
@david First in yellhow had a lookup formulas. Gone. The lookups formula ok, i can do again, but, and the informations in this second yellow field??? They had chose values there, and has gone. 😢 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fb91bb4ef10633b6295c657f49b0b30dcc2d9249.png) More Lookup formula. Gone. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8b0b899cea751dc931d961528c08e3e8a5c659e1.png) ---
**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, 4:42pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/4 "2020-04-18T16:42:54Z")
When editing a record, do you have any components that are attempting to fill the column where you have the formula? If so, the formula will get overwritten. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 18, 2020, 4:54pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/5 "2020-04-18T16:54:35Z")
@Jeff_Hager i know it, and no. There’s no record that fill this columns. The values and formulas just had gone. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [April 18, 2020, 5:57pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/6 "2020-04-18T17:57:51Z")
Yesterday at 7:27pm Pacific Time somebody deleted that row via the app. ---
**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:08pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/7 "2020-04-18T18:08:14Z")
If you are using array formulas in the first data row, then you run the risk of it being deleted. There are several posts in the past about how to handle this. Some people like to build their formula in the header row. I like to use 2 header rows. Either ways prevents a data row with formulas from being manipulated and deleted in the app. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 18, 2020, 6:39pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/8 "2020-04-18T18:39:42Z")
What? The app? I didnt do anything by here, and the client have the access Damn… ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 18, 2020, 6:40pm UTC](https://community.glideapps.com/t/all-lookup-formulas-and-some-informations-has-gone/7316/9 "2020-04-18T18:40:38Z")
That’s why im changing a lotta formulas to use directly on Data from Glide ---
**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")
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)