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

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    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

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!