Count of all rows that do NOT have a completed status
I'm trying to get a count of all cases that are not complete (aka open), to use on a dashboard metric widget. Eventually I'd probably like to be able to have a metric widget showing the count of cases that are in each status EXCEPT complete. I've dug around on the communities and I can't seem to get it to work.
This is what I have so far but in gives me an invalid ref error:
It should in this case kick back 5. I had another version of the equation and it gave me 2.
Answers
-
Hi @Sarah Daley,
It may simpler than what you are attempting.
See if this works for you. =COUNTIF(Status:Status, <>"Complete")
You're example shows Status as a cross-sheet reference. If that's the case, substitute that in the above formula.
Hope this helps,
Dave
-
You need to define your range as Status:Status. The two ways you can get what you are looking for are either:
=COUNT(Status:Status) - COUNTIF(Status:Status, "Complete")
or
=COUNTIF(Status:Status, "<>Complete")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!