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

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!

Find more posts tagged with

Healthcare

Formulas

Project Management

Comments

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