Countif Blanks with an OR function


I am trying to build out my metrics sheet, with a long Countifs formula with multiple criteria. One of the criteria I need is: Count the number of cells in a range if either of a date column is Blank. I keep getting the #INVALID DATA TYPE Error. My formula looks something like:

=OR(COUNTIF({Date Range 1}, ISBLANK(@cell)), COUNTIF({Date Range 2}, ISBLANK(@cell)))

Can someone please help?


  • Dakota Haeffner
    Dakota Haeffner ✭✭✭✭✭

    Just a thought, have you tried using "" instead of ISBLANK?

    For Example:

    =OR(COUNTIF({Date Range 1}, ""), COUNTIF({Date Range 2}, ""))

    If you Data Ranges are columns you should get a value returned if the cell is empty. If that doesn't work try adding in the @cell pieces.

    Let me know if you have any luck!

    I use this formula to track my User Acceptance Testers work statuses and it works for me.

    =COUNTIFS({Request - UAT Assigned}, ="Teji XXXXX", {Request - Rally Status}, ="")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!