Countifs and Is not blank


I am trying to create a formula where it counts the number of rows when an invoice has not been approved. This is what I have and instead of changing the name for each person, I want to create one where it counts when the Approver column is not blank.

=COUNTIFS({Approver4}, "Eric Delie", {Hold}, "")

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Try: =COUNTIFS({Approver4}, NOT(ISBLANK(@celly@cell)), {Hold}, "")

    @cell references each cell in the range. No need to change that. Are you getting an error or incorrect response?


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!