How do I make this formula count blanks?

Hi, How do I make this count blanks?

=COUNTIFS({Range 2}, "name", {Range 1}, "30 days", {Range 3}, "Ready Re-insp" {Range 3}, "ISBLANK")) I've tried Range 3}, " "))

Thank you

Kim

Tags:

Answers

  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭✭

    Hey,

    Have you tried adding an IFERROR where if the cell is blank you can add a - then add the countif that column has a -

    Just a thought and hopefully that will help.

    Ken Armstrong

    Smartsheet Operations Analyst, Carelon Medical Benefits Management

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!