COUNT Formula for projects in multiple different statuses
Hello!
I am creating a metrics page and am trying to create a formula to count the number of projects with different statuses.
I want the formula to count ONLY projects with the project type at "Contract" AND that are in the status of either "Not Started" or "In Progress"
I have 2 separate formulas to count the total number of projects for both not started and in progress, but not sure how to combine the 2 into a single formula.
Current "Not Started" formula: =COUNTIFS({Type}, ="Contract", {Status}, =[Primary Column]@row)
Current "In Progress" formula: =COUNTIFS({Type}, ="Contract", {Status}, =[Primary Column]@row)
Would it be easier to created a formula counting all contracts not in the complete status?
thanks!
Answers
-
Hey Brooke,
I hope I understand you correctly.
You can use 1 COUNTIFS formula to count yoru projects.
Can you send a screenshot of the data sheet to help me understand the columns?
Thank you
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!