How many Escalations this year

I do not understand why this formula will not work.

I have an Escalation Year column (text/number) that extracts the year out of the Escalation Date (date) column.

I need to know how many escalations so far in 2023. I have tried countless variations of =COUNTIF([Escalation Year]:[Escalation Year], ="2023") and nothing works. I have also tried =COUNTIF([Escalation Year]:[Escalation Year], =YEAR(TODAY())), and COUNT(Escalation Year ="2023", "Yes. "No").

What is wrong with my formulas?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!