2

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

 

Functionality

Comments

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