Why does my report not counting the blank cells when it does have a section for blank?
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
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!