Formula for Health column

I would like the color of the circle in the Health column (formatted from a drop down list of RYGB balls) to change based on the status selected in the previous column containing a drop down list of "Not started", "In Progress", "Behind" and "Completed". Is this possible?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!