# Detect frozen rows as headers

**URL:** <https://community.glideapps.com/t/detect-frozen-rows-as-headers/1730>\
**Category:** Feature Requests\
**Created:** [November 6, 2019, 12:18pm UTC](https://community.glideapps.com/t/detect-frozen-rows-as-headers/1730 "2019-11-06T12:18:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\
**Post date:** [November 6, 2019, 12:18pm UTC](https://community.glideapps.com/t/detect-frozen-rows-as-headers/1730/1 "2019-11-06T12:18:10Z")

</div>

Hey Guys,  
I often use two rows for headers, where I use the first row as a header and the row below it to use for formulas, generally arrayformulas to apply to that column.

The problem I often have is when using inline lists, the formula row appears as an empty entry on top of the others in the inline list.

To fix this I often just apply a filter, normally to whatever row ID I am using and filter if it’s not empty. That works except if I want to apply any other filter.

Is there a way to ignore that row without using the filter so I can use the filter with a if then column?

Thank you

---

<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:** [November 6, 2019, 1:48pm UTC](https://community.glideapps.com/t/detect-frozen-rows-as-headers/1730/2 "2019-11-06T13:48:28Z")

</div>

Take a look at this method. Maybe this would work for you.

> [@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:** ![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:** [November 6, 2019, 3:53pm UTC](https://community.glideapps.com/t/detect-frozen-rows-as-headers/1730/3 "2019-11-06T15:53:12Z")

</div>

@George_B has an excellent option, but I’ll throw in a second option as I’m big on 2 row headers as well. I add an IF statement that will check if a certain column in a row is empty. If it is, then I display a blank. Blank rows will not show in the inline list.

> [@Arrayformula](https://community.glideapps.com/t/arrayformula/897/2):
>
> Try this in column C2: =arrayformula(IF(LEN(A2:A) = 0, “”, “image url”)) You may need to use “;” instead of “,” depending on the country you live in.