"Health" Column Symbols

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"))))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!