ISBLANK Question

Todd Smelser

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?

Bassam Khalil

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

Todd Smelser

Many thanks Bassam. This works for me. Cheers!

Bassam Khalil

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

Todd Smelser

Many thanks Bassam. This works for me. Cheers!

Bassam Khalil

@TSmelser

You are welcome and I will be happy to help you any time.