Formula to display when a task is late based on start date and status/% complete

mmurphy14986

I'm looking to develop a formula that will visually (either text or symbol) show when a task is overdue based on a Start Date and the, either, status or % complete.  I've tried to combine the RGY or the Harvey ball but that is using only one parameter and I need both columns.

Thanks in advance community!

Marcus Odum

Assuming you have a Start Date and Status (drop down) column you will get a red for late and green for on time.

=IF(AND([Start Date]1 < TODAY(), Status1 <> "Complete"), "Red", "Green")

mmurphy14986

That worked!

Thank you