How to count rows created in a specific year

jmo ✭✭✭✭✭✭

Hi team - I have a sheet that has a date field called Issue Status Date. How do I do a count of rows that have 2019, 2020 and 2021 in the date field?

So I need 3 separate formulas for counts by year but if I have 1 I can modify for the other years.

Appreciate any suggestions.



Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @jmoser

    Try this

    =COUNTIFS([Issue Status Date]:[Issue Status Date], ISDATE(@cell), [Issue Status Date]:[Issue Status Date], YEAR(@cell)=2019)

    This will only look for valid dates. Change the date for your other years.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!