Health Formula

Kelsey L DeOrdio

In my task sheet health column I am trying to write a formula that I desperately need help with. I have a column labeled status. It is a drop down column where I can select "Not Started", "In Progress", or "Complete". I would like my health column to reflect a color based on the input in the status column. Green if it is "Complete", yellow if it is "In Progress", red if "Not Started".

Paul Newcome

Try this:

=IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Yellow", "Green"))

Paul Newcome

Try this:

=IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Yellow", "Green"))

Kelsey L DeOrdio

@Paul Newcome Thank you so much!

Paul Newcome

Happy to help. 👍️