Comments not blank for current year
I'm getting an incorrect argument set on this sheet summary formula. I'm capturing the count of non-blank comments for the current year. Can you tell me where I went wrong? I tried changing to count if and same error.
=COUNTIFS(Comments:Comments, NOT(ISBLANK(@cell), Created:Created, IFERROR(YEAR(@cell, 0) = YEAR(TODAY()))))
Help Article Resources
Check out the Formula Handbook template!