# JOINing an array based on a condition in a form-entry sheet **URL:** \ **Category:** Ask for Help\ **Created:** [March 18, 2020, 8:36pm UTC](https://community.glideapps.com/t/joining-an-array-based-on-a-condition-in-a-form-entry-sheet/5551 "2020-03-18T20:36:24Z")\ **Posts on this page:** 1\ **Showing post:** 7
**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:** [March 21, 2020, 8:10pm UTC](https://community.glideapps.com/t/joining-an-array-based-on-a-condition-in-a-form-entry-sheet/5551/7 "2020-03-21T20:10:24Z")
I feel it’s pretty flexible. If you needed to add another column, you would simply just need to add another piece, like `& IF(E2:E = TRUE, E1 & ", ", "")` and that could be reduced by removing the ‘= TRUE’ as it should still check against true. Like this `& IF(E2:E, E1 & ", ", "")`. But if you got something that works for you, go for it. As for the second row… Some people like to join the column heading and formula in the first row (see @Robert_Petitto’s example) . I like putting my formulas in their own row. I do it in the second row without data because if the formula is in a data row and that row is ever deleted, then you lose your formula as well. My way isolates the formula from any data. As long as you structure the array formula with an If statement, (where I check for length of a particular column) then Glide will not see the second row as it appears empty. I tend to freeze my top 2 rows for my own reasons, but I think there is a little known feature that might work for you. Freeze your top 2 rows for your header and intermediate formula and Glide will ignore any visible data in the second row. I have not really tried that myself, but it sounds like an option that might work. > [@Components not showing](https://community.glideapps.com/t/components-not-showing/2776/3): > > We recently made a change in how Glide recognizes row headers. Previously Glide would guess, but sometimes the guess was wrong, and the only thing to do was to change your sheet. Now Glide will interpret frozen rows to mean that the frozen rows are the header. In your About sheet you’ve frozen the header as well as the data row, however, so the data row is interpreted as the header, and the table is empty. Just unfreeze the rows, or use a single frozen row and you should be good. --- _[View the full topic](https://community.glideapps.com/t/joining-an-array-based-on-a-condition-in-a-form-entry-sheet/5551)._