Count Number of Cells within 2021 or specified Year

Frank Dean
Frank Dean ✭✭✭
edited 06/09/21 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!