Return "Late" if date is passed and box is unchecked

Pam Grant

I have 3 columns: Planned Date, Completed Checkbox, Late

I want a formula to put "Late" in the (Late Column) IF the (Planned Date) is passed and (Completed) is unchecked. If it is not late, I want to leave the Late cell blank.  I want this to show on every row. 

Here is my formula for row 2.  I'm getting #INCORRECT ARGUMENT

=IF(AND([Planned Date]2 < TODAY()), IF([Completed]2, 0), "Late", "")

Any thoughts?

Brian W

You're almost there. Try it like this:

=IF(AND([Planned Date]2 < TODAY(), Completed2 = 0), "Late", "")

Tip: You can also use @row in place of the row number and Smartsheet will automatically apply the current row:

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