Countif formula; exclude completed status
Hello,
I currently have the formula to count how many priority levels each team has but would like to exclude the completed items from the count. Is there an additional piece of the formula that I need to include?
Best Answer
-
Try this formula
=COUNTIFS([Priority Level]:[Priority Level], "Medium", [Team Owner]:[Team Owner], "CLSRG", [Status]:[Status], <>”Completed”)
Answers
-
Add another condition to your COUNTIFS for [Status]2:[Status]62, <>”Completed”
-
How would I add the condition to this formula since the different variations that I have tried haven't been working?
=COUNTIFS([Priority Level]:[Priority Level], "Medium", [Team Owner]:[Team Owner], "CLSRG")
-
Try this formula
=COUNTIFS([Priority Level]:[Priority Level], "Medium", [Team Owner]:[Team Owner], "CLSRG", [Status]:[Status], <>”Completed”)
-
Thanks that worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!