CountIfs with year-function over reference cloumn

KROnline ✭✭
edited 02/22/23 in Formulas and Functions


I'm using the countifs function over a cross reference to another sheet with several counts very well.

But now I want to count, if a date in a reference sheet is in the current year. And I don't want to use a seprate column, where I have only the year.

So I tried the following:

=COUNTIFS(YEAR{Refererence}), 2022) where reference is the column of another sheet with the date I want to check.

So my question is about how to use function on a reference column



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!