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

Pam Grant · 07/10/19

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 · 07/10/19

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", "")

Pam Grant · 07/11/19

Thank you Brian W! That worked for me.

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

Comments

Help Article Resources

Categories