Sheet reference Countifs formula with a date
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!