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()))))


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Amy Swan

    When using a function within a COUNTIFS, the function needs to be closed off as part of the criteria. The closing parentheses were placed at the end of the COUNTIFS instead.

    =COUNTIFS(Comments:Comments, NOT(ISBLANK(@cell)), Created:Created, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

    Will this work for you?

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!