COUNTIF Only if System Generated Date Column is Current Year

Sara_Cook
Sara_Cook Overachievers Alumni
edited 12/16/19 in Formulas and Functions

I am trying to create a formula in a Sheet Summary field that displays the total number of rows I have in the sheet that were created in the CURRENT YEAR. I have a system-generated date column - the column is titled "Created".


The only criteria is that the Created column has a date and that the date is in the current year.


I cannot figure out how to use a COUNTIF formula to display only the number of rows that have a date in the current year. I've looked through the discussions and have seen different variations, but none of them work.


The system-generated date column has a xx/xx/xx format for the month/day/year - so I wonder if that has something to do with it? I've been trying to use YEAR or DATE in my formulas, but they all seem to want a 4 digit year.


This seems like it would be simple - just count the current year. I'm hoping there is a simple solution that I'm just missing.


Thanks!!


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!