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
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …