Flag task as late where task incomplete and past due date

leezee

Please help, I am trying to flag late tasks in a column using the following formula... I am getting a #INCORRECT ARGUMENT SET error...Please help

=IF(AND(Status27 <> "Complete", (Finish27 < =TODAY()), "red"))

 

 

thanks

 

Andrée Starå

Hi @Cory Rubino

I hope you're well and safe!

Try something like this.

=IF(Finish@row <> "", (IF(AND(Status@row <> "Complete", Finish@row <= TODAY()), "Red")))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nic Larsen

You just had an extra bracket in there you didn't need before "finish".

Try this:

=IF(AND([Status]@row<> "Complete", [Finish]@row<= TODAY()), "Red")

leezee

Thank you Nic! works perfectly !

 

Cory Rubino

This is probably an easy question, but how would I go about using this formula but leave the cell blank if a Finish date has not been entered?

Thank you in advance!

Andrée Starå

Hi @Cory Rubino

I hope you're well and safe!

Try something like this.

=IF(Finish@row <> "", (IF(AND(Status@row <> "Complete", Finish@row <= TODAY()), "Red")))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Cory Rubino

Hello @Andrée Starå!

That did the trick! I really appreciate the quick response.

Andrée Starå

@Cory Rubino

Excellent!

Happy to help!