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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives