How do I make this formula count blanks?

Options
Kimbh
Kimbh ✭✭✭✭
in Formulas and Functions

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}, " "))

ISBLANK.png

Thank you

Kim

Tags:
· Share on FacebookShare on Twitter

Answers

  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭✭
    Options

    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!!!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!