Formula assistance
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?
Best Answer
-
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")))
Answers
-
What are your requirements for health? Do you have any attempts you've already made a formula? What are your requirements?
-
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?
-
(Deleted) See follow up response below.
-
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")))
-
ALAS! Thank you
-
You're welcome!
Help Article Resources
Categories
Check out the Formula Handbook template!