Why does my report not counting the blank cells when it does have a section for blank?

Idaly
ββ
In this screenshot, it shows that in fact there are 3 cells with status blank however on the count it comes with 0 instead of 3. Can you tell me if there is a fix to this? Please let me know
Best Answer
-
Hi,
I think this is because you are counting on an empty value. If you switch the summarize to 'Sheet Name' for example, it will count the items that it has grouped as they all have a clause to count.
Tim
Answers
-
Hi,
I think this is because you are counting on an empty value. If you switch the summarize to 'Sheet Name' for example, it will count the items that it has grouped as they all have a clause to count.
Tim
-
Thank you so much! This definitely fixed it
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!