Filter by year

I am trying to count meetings based on the week number and year. I have the week number but can't figure out how to filter by year. As an example, my current formula for week #44 is

=COUNTIF({IT Meeting}, IFERROR(WEEKNUMBER(@cell), 0) = 44)

How do I filter for 2021 or 2022?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!