Summary Report pulling tasks count based on items checked
I need a count formula or any formula that counts the number of late, not started, complete and in progress tasks that has milestone or key activity checked. The purpose is to create a semi-circle chart (sample chart below is the count that will pull into a summary report) on a dashboard to show the different counts.
- Milestone Level For example: Count will return the number 1 = Late, 0 = Complete, 0 = in progress, & 0 = not started
- Key Activity Level For example: Count will return the number 0 = Late, 2 = Complete, 0 = in progress, & 0 = not started
- Milestone/Key Activity For example: Count will return the number 1 = Late, 2 = Complete, 0 = in progress, & 0 = not started
Best Answer
-
Milestone - Late:
=countifs(milestone:milestone, 1, status:status, "Late")
Key activity - Late:
=countifs([key activity]:[key activity],1,status:status,"Late")
You could then replace "Late" with "Complete", "In Progress", and "Not Started" in fields for each of the other status.
Hope this helps!
Best,
Heather
Answers
-
Milestone - Late:
=countifs(milestone:milestone, 1, status:status, "Late")
Key activity - Late:
=countifs([key activity]:[key activity],1,status:status,"Late")
You could then replace "Late" with "Complete", "In Progress", and "Not Started" in fields for each of the other status.
Hope this helps!
Best,
Heather
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!