Is it possible to color code the Empty, Quarter, Half, Three Quarter, and Full Harvey balls?

I'd like to combine 2 input columns into a single color coded harvey ball. For simplicity lets say 1 column is ProgressInput (Empty, Quarter, Half, etc) and the other is StatusInput (Red,Yellow, Green). For the output column on a dashboard report I would want to see a quarter-full ball with either red, yellow, green or a half-full ball colored either red, yellow, green. Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!