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.
Thanks,
Jeff
Best 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.
cheers
Answers
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!