Flag task as late where task incomplete and past due date

leezee
leezee ✭✭
edited 06/23/22 in Formulas and Functions

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

 

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!