Nested Criteria
![Admin](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to count all "Implemented" and "To Implement" instances in "CS Status" drop down for the current month and year ("Created Date"). I keep getting nested criteria error. I am sure I have put too much information in but can someone help please?
=COUNTIFS([Created Date]:[Created Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) + COUNTIFS([CS Status]:[CS Status], @cell = "Implemented") + COUNTIFS([CS Status]:[CS Status], @cell = "To Implement")))
Answers
-
@Admin When I ran into a formula error I dissect it by adding a helper column for each section. Column 1 for COUNTIFS([CS Status]:[CS Status], @cell = "To Implement"), column 2 for COUNTIFS([CS Status]:[CS Status], @cell = "Implemented")… Or in order to make it work maybe you need these helper columns instead of having too many countifs nested. Hope this helps
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives