Count cells within a row

Ask for Help
1

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.

2
  • 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
2 Likes
3

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
image641×541 39.3 KB

Thanks!

4

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

5

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.

6

Safe on my side. Could the bug be local?

Screenshot 2024-09-21 at 19.11.53
Screenshot 2024-09-21 at 19.11.531098×692 24.9 KB

7

Dunno, there have been some weird issues with computed columns recently :man_shrugging:

1 Like
8

image
image1088×679 93.5 KB

Seems it works fine now. I refresh glide and suddently worked.

Thanks for your advice!

Have a nice weekend

1 Like