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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!