Count the number of lines, based on the creation date column

Kinnari S.
Kinnari S. ✭✭
edited 02/20/23 in Formulas and Functions


Can anyone help me with the formula? I have a sheet with approx 400 lines of which the creation date is automatically generated.

I would like to count how many lines were created in the year of 2020, 2021 and 2022 based on that column.

Thank you for helping me out!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!