AND statement in smart sheet

TDXEV

I am having issues getting results back when using AND statement

I am trying to compare two conditions, and show if an action is late or not using the following formula

I want to say if the End date is before today and the completed is blank then the action is late.

the line circled in red should show 1 cause both criteria's are true but it still shows 0

=IF(AND([End Date]@row<TODAY(),Completed@row=" "), 1, 0)

Joe M.

Hello,

Try this formula:

=IF(AND([End Date]@row < TODAY(), ISBLANK(Completed@row)), 1, 0)

This should work when the Completed column type is set to date format.

TDXEV

I also tried this

=IF((AND(ISBLANK([Completed@row])),[End Date]@row < TODAY()), "Late", "OnTime")

Leibel S

@TDXEV

Try this:

=IF(AND([End Date]@row<TODAY(),ISBLANK(Completed@row)), 1, 0)

Joe M.

Hello,

Try this formula:

=IF(AND([End Date]@row < TODAY(), ISBLANK(Completed@row)), 1, 0)

This should work when the Completed column type is set to date format.

TDXEV

Thank you so much everyone