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


On Hold

In Progress



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


2 "on Hold"

10 "Completed"

35 " In Progress"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!