Summary Report pulling tasks count based on items checked

Denera McCullough

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

Heather Duff

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

Heather Duff

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