"Health" Column Symbols

Detrie Zacharias

My Health Column Type is Balls

I need to set the ball colors like this:

Red if Due Date is before Today

Yellow if Due Date is Today

Green if Due Date is After Today

Blue if Status is not "Complete" "On Hold", Cancelled" or "Rejected"

This part works

=IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row = TODAY(), "Yellow", IF([Due Date]@row > TODAY(), "Green")))

I cant get the blue to work and I'm not sure how to add multiple values to the formula

=IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row = TODAY(), "Yellow", IF([Due Date]@row > TODAY(), "Green", IF(Status@row <> "Complete" OR "On Hold" OR , "Blue"))))

Paul Newcome

Try moving it to the start of the formula:

=IF(OR(Status@row = "Complete", Status@row = "On Hold"), "Blue", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row = TODAY(), "Yellow", IF([Due Date]@row > TODAY(), "Green"))))

Paul Newcome

Try this:

=IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row = TODAY(), "Yellow", IF([Due Date]@row > TODAY(), "Green", IF(OR(Status@row <> "Complete", Status@row <> "On Hold"), "Blue"))))

Detrie Zacharias

Thanks Paul

I misspoke in my original post. I meant to say = rather than <>.

In any event, this does not fire the Blue part

=IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row = TODAY(), "Yellow", IF([Due Date]@row > TODAY(), "Green", IF(OR(Status@row = "Complete", Status@row = "On Hold"), "Blue"))))

This bit works on its own but not when included with the rest

=IF(OR(Status@row = "Complete", Status@row = "On Hold"), "Blue")

Paul Newcome

Try moving it to the start of the formula:

=IF(OR(Status@row = "Complete", Status@row = "On Hold"), "Blue", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row = TODAY(), "Yellow", IF([Due Date]@row > TODAY(), "Green"))))

Detrie Zacharias

Ah.. That was it..

Thanks Paul

Paul Newcome

Happy to help. 👍️