AND statement in smart sheet

TDXEV
TDXEV ✭✭✭
edited 05/16/22 in Smartsheet Basics

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)

Best Answer

Answers