Countifs Formula for Current Month and Year


I am trying to count the number of documents with closed status for the current month/year. I am having difficulty with the formula. Here is what I have so far:

=COUNTIFS(([Closure Actual]:[Closure Actual], IF(ISDATE(@cell), MONTH(@cell)=MONTH(TODAY()))), [Closure Actual]:[Closure Actual], IF(ISDATE(@cell), YEAR(@cell)=YEAR(TODAY())), [Stage Status]:[Stage Status], "Closed")

Can someone help.

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    That's a possibility - I'm not sure. Try changing your year/month formulas to this:

    For the Year column:

    =if(isblank([closure actual]@row),"",YEAR([closure actual]@row))

    For the Month column:

    =if(isblank([closure actual]@row),"",MONTH([closure actual]@row))

    That should do away with the errors, and we can see if that fixes the formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!