How to count rows created in a specific year

Options
jmo
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.

Thanks,

Jeff

Best Answer

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

    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.


    cheers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!