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

Pam Grant
Pam Grant ✭✭
edited 12/09/19 in Formulas and Functions

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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!