COUNTIFS with multiple criteria
I am trying to count the number of projects with a due date in the past and a Status of In Progress, In Review, or On Hold. This is what I have, but it returns unparseable.
=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY (), [Status:Status, ="In Progress"], [Status:Status, ="In Review"], [Status:Status, ="On Hold"])
Can you help?
Thanks.
Best Answer
-
Looks like you have a few sets of brackets where they don't need to be, you have a space at the end of TODAY function that is causing problems, and you need an "OR" condition. Try this instead:
=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY(), Status:Status, OR(@cell="In Progress", @cell= "In Review", @cell= "On Hold"))
Hope this helps!:)
Answers
-
Looks like you have a few sets of brackets where they don't need to be, you have a space at the end of TODAY function that is causing problems, and you need an "OR" condition. Try this instead:
=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY(), Status:Status, OR(@cell="In Progress", @cell= "In Review", @cell= "On Hold"))
Hope this helps!:)
-
Thanks! That worked!
-
Awesome! Glad to hear it:)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!