Formula assistance

Andre de Oliveira

I have 3 columns (Health, Status, Due Date) and im struggling to get my formula right to activate the health symbol in my health column. Please assist. The status column is straight forward (In progress, Not Started and Complete).

Please can someone assist?

Mike Wilday

Whoops forgot some quotes.

=IF(Status@row = "Complete", "Green", IF(AND(Status@row <> "Complete", Today() > [Due date]@row), "Red", IF(Status@row = "Not Started", "Blue", "Yellow")))

Mike Wilday

What are your requirements for health? Do you have any attempts you've already made a formula? What are your requirements?

Andre de Oliveira

At the moment, im trying to copy the formula from one of the templates..

=IF(State3 = "Complete", "Green", IF(AND(State3 <> "Complete", TODAY() > [End Date]3), "Red", IF(AND(State3 = "Not Started"), "Blue", "Yellow")))

The only difference on my sheet is that there is no start and end date. Just a due date. However the same principals apply... if its complete, the health will be green. If its not complete by the due date then its red.

Any suggestions?

Mike Wilday

(Deleted) See follow up response below.

Mike Wilday

Whoops forgot some quotes.

=IF(Status@row = "Complete", "Green", IF(AND(Status@row <> "Complete", Today() > [Due date]@row), "Red", IF(Status@row = "Not Started", "Blue", "Yellow")))

Andre de Oliveira

ALAS! Thank you

Mike Wilday

You're welcome!