# Help using filter and getting two results

**URL:** <https://connect.superhuman.com/t/help-using-filter-and-getting-two-results/8420>\
**Category:** Ask the Community\
**Created:** [June 4, 2019, 7:07am UTC](https://connect.superhuman.com/t/help-using-filter-and-getting-two-results/8420 "2019-06-04T07:07:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Juanmata](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/juanmata/32/8814_2.png) [@Juanmata](https://connect.superhuman.com/u/Juanmata)\
**Post date:** [June 4, 2019, 7:07am UTC](https://connect.superhuman.com/t/help-using-filter-and-getting-two-results/8420/1 "2019-06-04T07:07:56Z")

</div>

Morning all

I’m using filter in a formula and I would like to get 2 results rather than just one.

For example:

[Board Materials].Filter(thisRow.Service=“Manufacture” AND thisRow.[Job Type].Contains(Range) AND thisRow.[Material Brand].Contains(Brand)).[Width (mm)] ,

That will give me the result of the ‘Width (mm)’ column.

I would like to get the results from ‘Length (mm)’ and Width (mm) columns.

I tried using using something like this:

`[Board Materials].Filter(thisRow.Service="Manufacture" AND thisRow.[Job Type].Contains(Range) AND thisRow.[Material Brand].Contains(Brand)).Concatenate("mm x ", [Board Materials].Filter(thisRow.Service="Manufacture" AND thisRow.[Job Type].Contains(Range) AND thisRow.[Material Brand].Contains(Brand)).[Length (mm)], "mm"),`

Although that works, it doesn’t work if the column has values separated with a comma.

---

<div class="post-metadata">

**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\
**Post date:** [June 4, 2019, 8:58am UTC](https://connect.superhuman.com/t/help-using-filter-and-getting-two-results/8420/2 "2019-06-04T08:58:57Z")

</div>

Hi @Juanmata,

In this case I would create one column with the formula to extract the “width” and another column to extract the “lenght” and in one column with concatenate to combine the values in the format you wish.

Maybe not the most elegant solution, but the result will be there.  
Does this make sense 😀

---

<div class="post-metadata">

**Author:** ![Juanmata](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/juanmata/32/8814_2.png) [@Juanmata](https://connect.superhuman.com/u/Juanmata)\
**Post date:** [June 4, 2019, 10:02am UTC](https://connect.superhuman.com/t/help-using-filter-and-getting-two-results/8420/3 "2019-06-04T10:02:17Z")

</div>

@Jean_Pierre_Traets

That does make sense but I was trying to stay clear of having extra columns for silly things like that,

---

<div class="post-metadata">

**Author:** ![Nick\_Milner](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nick_milner/32/8249_2.png) [@Nick\_Milner](https://connect.superhuman.com/u/Nick_Milner)\
**Post date:** [June 4, 2019, 11:36am UTC](https://connect.superhuman.com/t/help-using-filter-and-getting-two-results/8420/4 "2019-06-04T11:36:44Z")

</div>

Adding logic in hidden columns is a core implementation mechanism in Coda - they’re almost like real-time function calls that operate on each row whenever something changes. They’re incredibly powerful.

Take a look at this truly excellent Work Breakdown Structure project for example. See how many hidden columns there are and how they’re used…

> [@Project Manangement with Folding of parent items](https://connect.superhuman.com/t/project-manangement-with-folding-of-parent-items/8364):
>
> While we dont have folding yet (and its definitely on our radar to make it easier to create folding/collapse of hierarchical data) - you can build it yourself in coda today. Here’s an example.