Count how many columns not empty in every row

jack_Liu · 12-06-2021 02:01 PM

Hi new to appshe

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

SkrOYC

Maybe…

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

Steve

This:

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

Aurelien

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 ?