Count columns with values

AppSheet AppSheet Q&A
1

How can I count columns with values.
Say I have 20 columns, how can I know the number of columns with values?

2

IFS(COUNT(Table[Col1])>0,1)+
IFS(COUNT(Table[Col2])>0,1)+
…

3

If you need to do this inside of one record instead of table level, you could use
IFS(ISNOTBLANK([Col1],1)+
IFS(ISNOTBLANK([Col2],1)+
etc.

4 Likes
4

It works. Thanks

5

You’re welcome