Chart to Display Count of Complete vs Incomplete
Comments
-
What i do is make another "Utility" sheet and use a COUNTIF()/ COUNTIFS() formula.
IE
Completed Items
=COUNTIF({Sheet Range 1}, "Completed")
Incomplete Items
=COUNTIF({Sheet Range 1}, "Incomplete")
After that use the Metric widget and display those items. It will auto update after you make changes in your sheet which is nice.
If you want more criteria use COUNTIFS() Like Completed items that are in "X" Department or whatever.
Michael
-
Thanks Michael!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives