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
-
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:
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!