Workaround Countif in a row

Hi everybody,

I wanted to share with you this solution to count the number of cells in a row that match given values ​​contained in a “choice” component.

Here is an example : https://mushy-hands-5054.glideapp.io/

It is very simple. The “choice” component returns 1 for the first choice and 0.00001 for the second.
A “Math” column is the sum. A new “Math” column with the TRUNC function determines the number of first choices and another with the MOD function indicates the number of second choices.
We can still add other choices by returning higher numbers in the column (100000000) and dividing the sum by this number before doing the TRUNC function.
If anyone needs it :wink: :wink: :wink:

3 Likes