How do I count how many projects are "In Progress" or "Completed" ?

HI There,

I feel this should be easy to figure out but i cant seem to! PLEASE HELP?!


I have a column called "STATUS" , I have a drop down menu with the following under Status

STAUS

On Hold

In Progress

Cancelled

Completed


How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled"

Ideally this will pull through onto a dashboard showing the below data

EG:

2 "on Hold"

10 "Completed"

35 " In Progress"

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @courtney jones

    Hope you are fine, please try the following formula:

    =COUNTIFS(STATUS:STATUS, CRITERIA@row)
    

    and in the dashboard add chart and select the data range using the table shown in the following screenshot:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!