# Count items (names) in a field that has multiple names selected

**URL:** <https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758>\
**Category:** Ask the Community\
**Created:** [June 19, 2023, 5:36pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758 "2023-06-19T17:36:49Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Remco\_de\_Louw](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/remco_de_louw/32/22914_2.png) [@Remco\_de\_Louw](https://connect.superhuman.com/u/Remco_de_Louw)\
**Post date:** [June 19, 2023, 5:36pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/1 "2023-06-19T17:36:49Z")

</div>

Hi All,

Maybe I am missing something very obvious, I have a name field with 3 names selected (example)  
 ![image](https://global.discourse-cdn.com/coda1/original/3X/5/5/55706e287c6e537a7aef58e4dbed2d39fd8df713.png) but when I do a count on that field I get 1 instead of 3.  
Is there a way to do a count that gives me 3 as a result?

---

<div class="post-metadata">

**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\
**Post date:** [June 19, 2023, 5:54pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/2 "2023-06-19T17:54:44Z")

</div>

Hi @Remco_de_Louw 😊 !

Per your screenshot you have a _list_ of names (which would count as 1 item) as illustrated by the squared brackets surrounding your names (`[`… `]`) and not just 3 names (3 items) 😊 …

Depending on how you get those names/your current setup, there might be multiple ways to count those names but I guess you could try to flatten the list using `ListCombine()`, maybe…

If this is a related column and this list of names is linked in a way or another to a relation/linked relation field, you might want to check if that field is set as multi-select… potentially 😊

---

<div class="post-metadata">

**Author:** ![Remco\_de\_Louw](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/remco_de_louw/32/22914_2.png) [@Remco\_de\_Louw](https://connect.superhuman.com/u/Remco_de_Louw)\
**Post date:** [June 19, 2023, 5:58pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/3 "2023-06-19T17:58:30Z")

</div>

Hi! Thanks for your reply.  
This is the formula that gets the data:  
Organisatie.Filter(Bedrijf=thisRow.Dealer.Bedrijf).Members  
The original field is also a formula : sort([Volledig Adresboek].Filter(Organisatie.Contains(thisRow)&&Conventie.Contains(Conventies.Filter(Active=true))),ascending: true)

---

<div class="post-metadata">

**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\
**Post date:** [June 19, 2023, 6:05pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/4 "2023-06-19T18:05:44Z")

</div>

Maybe you could try this 🤔 …

```auto
Organisatie.Filter(Bedrijf=thisRow.Dealer.Bedrijf).Members.ListCombine()

```

---

<div class="post-metadata">

**Author:** ![Remco\_de\_Louw](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/remco_de_louw/32/22914_2.png) [@Remco\_de\_Louw](https://connect.superhuman.com/u/Remco_de_Louw)\
**Post date:** [June 19, 2023, 6:23pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/5 "2023-06-19T18:23:52Z")

</div>

Thanks for the suggestion, that makes it all one item as well, I got it to work but I don’t really understand why. The original column was a text field with a formula, I now made it a select list with the same formula and then it works? Weird haha.

---

<div class="post-metadata">

**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\
**Post date:** [June 19, 2023, 6:58pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/6 "2023-06-19T18:58:45Z")

</div>

hi @Remco_de_Louw ,

we don’t see the table, so we have no idea about the values in living in the display column, but  
could you try this in which I assume that the column Dealer is the display column.

```auto
Organisatie.Filter(Bedrijf.Contains(thisRow.Bedrijf)).Members

```

Cheers, Christiaan

---

<div class="post-metadata">

**Author:** ![Remco\_de\_Louw](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/remco_de_louw/32/22914_2.png) [@Remco\_de\_Louw](https://connect.superhuman.com/u/Remco_de_Louw)\
**Post date:** [June 26, 2023, 7:54pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/7 "2023-06-26T19:54:10Z")

</div>

I will try this, Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [September 24, 2023, 7:54pm UTC](https://connect.superhuman.com/t/count-items-names-in-a-field-that-has-multiple-names-selected/40758/8 "2023-09-24T19:54:47Z")

</div>

Closed on September 24, 2023, 7:54pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.