Count how many columns not empty in every row

AppSheet AppSheet Q&A
1

Hi new to appshe

3X_7_8_78ffe0e75d78adf44635efb70ab6e62c771e25b7.png
3X_7_8_78ffe0e75d78adf44635efb70ab6e62c771e25b7.png573×301 2.72 KB

et, want to know is there any way to count how many colunms are not empty in each rows.

2

Maybe…

COUNT(
  LIST(
    [Location 1],
    [Location 2],
   ...
  )
)
3 Likes
3

This:

SUM(
  LIST(
    IFS(ISNOTBLANK([location1]), 1),
    IFS(ISNOTBLANK([location2]), 1),
    ...
  )
)
3 Likes
4

Hi @Steve

Just curious: why do you suggest a solution with IFS() instead of @SkrOYC 's suggestion ?
If [location1] is blank, that will provide an empty value ?

According to this:

we know that: COUNT(LIST()) ==> 0
Then, I would assume: COUNT(LIST("")) ==> 0
and therefore: COUNT(LIST("a","")) ==> 1

Am I correct or wrong ?
Thank you in advance for your explanation

EDIT: I just tried it, and my assumption was wrong
COUNT(LIST("")) ==> 1.
so, it will be: COUNT(LIST("a","")) ==> 2

@Steve , would it be possible to add this case: COUNT(LIST("")) among the examples of the documentation ?

3 Likes