Sheet reference Countifs formula with a date

Options

Hello,

I have a column that's a date and need a formula on a separate sheet to count if the date is current year. I haven't been able to find any community posts about sheet references, only cross sheet ones.

Current formula: =COUNTIF({Date Column}, ISDATE(>2023)). I get an invalid ref error.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!