Countifs on percent complete, month, and year
Is it possible to create a countifs statement like the following: =COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish],AND(IFERROR((YEAR(@cell), 0) = 2018),IFERROR((MONTH(@cell), 0) = 2)) ? I am trying the following equation to search for 100% complete and during a specified month and year. I am getting a #unparseable error when tying the equation. I have success with a similar equation: =COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish], IFERROR(YEAR(@cell), 0) = 2017)
Comments
-
Hello,
The issue here is that you're including an AND function within your formula.
When using the COUNTIFS there is an implied AND between each range/criteria combination so you do not need to use an AND function, simply add another range/criteria set.
Your final formula will look like this:=COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish], IFERROR(YEAR(@cell), 0) = 2018, [Project Finish]:[Project Finish], IFERROR(MONTH(@cell), 0) = 2)
Thanks!
Schiff
Smartsheet Support
-
Schiff, thanks, works perfectly now!