# Count cells within a row

**URL:** <https://community.glideapps.com/t/count-cells-within-a-row/76528>\
**Category:** Ask for Help\
**Created:** [September 21, 2024, 11:10am UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528 "2024-09-21T11:10:16Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [September 21, 2024, 11:10am UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/1 "2024-09-21T11:10:16Z")

</div>

Hello everybody,

I would like to find a quick way of counting filled cells in certain row.

The app register diferent dates in the same row and we want to count the ones that have been filled. For example:

Cell1: 25/09/2024, Cell 2: 26/09/2024-\> A column counts 2  
Cell1: 25/09/2024, Cell 2: 26/09/2024, Cell 3: 30/09/2024-\> A column counts 3

Is that possible?

Any tips will be apreciatte.

Many thanks.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 21, 2024, 11:18am UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/2 "2024-09-21T11:18:51Z")

</div>

- Use a Make Array column to create an array from all columns that you want counted
- Take a rollup-\>count of the Make Array column

---

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [September 21, 2024, 11:38am UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/3 "2024-09-21T11:38:30Z")

</div>

Hi Darren,

Thanks for your answer, I did the array but for some reason the roll up is not working. When I pick up the array column the filed remains “none” so I cannot keep going with the counting. Here an image:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28c1f237735bd3f6fc13450b46b8d71e3b81a9dc.png)

Thanks!

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [September 21, 2024, 11:45am UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/4 "2024-09-21T11:45:49Z")

</div>

The target of your roll up column is to find array columns that are located outside of the sheets.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 21, 2024, 11:56am UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/5 "2024-09-21T11:56:47Z")

</div>

> [@Albert\_Puig](#):
>
> When I pick up the array column the filed remains “none” so I cannot keep going with the counting.

mmm, I can replicate that behaviour. I believe it’s a bug.

I guess a workaround would be to create a joined list from the array, then pass that to a JavaScript column.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [September 21, 2024, 12:12pm UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/6 "2024-09-21T12:12:50Z")

</div>

Safe on my side. Could the bug be local?

 ![Screenshot 2024-09-21 at 19.11.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d05f53900a6df90151710126a36402b5e97c0a74.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 21, 2024, 12:14pm UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/7 "2024-09-21T12:14:31Z")

</div>

Dunno, there have been some weird issues with computed columns recently 🤷‍♂️

---

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [September 21, 2024, 1:25pm UTC](https://community.glideapps.com/t/count-cells-within-a-row/76528/8 "2024-09-21T13:25:59Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d30518c2438963ea59eacbec477ddca8fdb08970.png)  
Seems it works fine now. I refresh glide and suddently worked.

Thanks for your advice!

Have a nice weekend
