ISBLANK Question

Todd Smelser
Todd Smelser ✭✭✭
edited 05/19/21 in Formulas and Functions

I need a qualifier to ignore blank cells in this formula:

=IF(AND([Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0)

Right now this is counting blank date fields as "1".

I see the ISBLANK modifier but is there a NOTBLANK argument in SS?

Best Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @TSmelser 

    Hope you are fine, please try the following formula

    =IF(AND(ISDATE([Due Date]@row), [Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0)

    the following screenshot shows the result

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Todd Smelser
    Todd Smelser ✭✭✭
    Answer ✓

    Many thanks Bassam. This works for me. Cheers!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!