Can't seem to get my health status to autopopulate the correct color based on the completion%.


I need the health status to turn red if <50%, yellow if 51%-79% and green if 80% and higher.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!