Count Number of Cells within 2021 or specified Year
Hey Folks,
This comes up alot and I tried my best. I am building a metrics sheet for a dashboard, and need to reference the ship date column on my other sheet. I need to count the number of ship dates in 2021 YTD (so Jan 1 - TODAY). So I can count total shipped YTD. Here is what I got, getting Unparseable. PM Backlog Range 1 is the shipping date column referenced from my other sheet.
=COUNTIFS({PM Backlog Range 1}, IFERROR(YEAR({PM Backlog Range 1}, 0)=year(TODAY))))
Best Answer
-
I think that you are just a little off, but I think this one should work....
=COUNTIF({PM Backlog Range 1}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
Answers
-
I think that you are just a little off, but I think this one should work....
=COUNTIF({PM Backlog Range 1}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
-
THANK YOU
-
What if I want to Count YTD? It is also counting stuff in November that hasn't shipped yet.
-
you could add another condition I believe something like...
=COUNTIFS({PM Backlog Range 1}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()),{PM Backlog Range 1},IFERROR(Month(@cell), 0) <= MONTH(TODAY()))
Help Article Resources
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
Check out the Formula Handbook template!