Count if formula to include multiple years


I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024?

Current equation: =COUNTIF({CI Tracker Range 1}, @cell = YEAR(TODAY()))

Thank you!


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @PaigeKucz

    This would do this year and last:

    =COUNTIF({CI Tracker Range 1}, OR(@cell = YEAR(TODAY()), @cell = YEAR(TODAY()) - 1))

    If you wanted specific years, then just sub out the "YEAR(TODAY()" portions of the formula for the relevant year .

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!