Blank cells (empty)

Q&A
, ,
1

What formula can count blank cells which are empty?
Some of my cells are null and some are empty, how can I aggregate them (count the number of null or empty)
I didnt find a ISBLANK formula

2

Hi @Etai_Fiedelman

are you talking about null or 0? Because null = empty. Or what is your differance between “null” and “empty”?

And for null you could use isNull

BR

3

There are cells that are empty with a space for example. So I understood i cant count them as null. Not 0

4

You could create a new field

ifelse(your_field=" " or isnull(your_field),null,your_field)

Or clean up the field on database level.

5

Thanks, the latter is irrelevant currently :slight_smile: