Counting Opened Opened for a Particular Year


I want to count the number of tickets that were opened in 2022. I am getting a invalid date type error message. The date range in the cross reference is restricted to dates only.

=COUNTIF({Date Requested}, YEAR(@cell) = 2022)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!