Hello there! Hoy can I count diferent values...

[Aparicio_Pineyr]

Hello there!

Hoy can I count diferent values from from several columns? I’m trying to do a COUNTa for each row of a table.

[Aleksi_Alkio]

I’m afraid we don’t have COUNTA as an expression. Instead of that you can use COUNT.

[Simon_Robinson]

You could always do COUNTA as a spreadsheet formula if this was viable.

But you’d need to sync to get the correct data

[Aparicio_Pineyr]

@Aleksi_Alkio

what kind of expression do I need to add between columns?

E.G.: COUNT([1],[2])…?

[Aparicio_Pineyr]

@Simon_Robinson

Yes, Do you know how can I create an Array Counta formula?