Traffic Lights/cell colour based on corresponding numeric value

edited 12/09/19 in Formulas and Functions

Hi, can anyone please help? I want to set up an alert system in SmartSheet that turns a cell green (and labelled 'on track') if a corresponding cell is >90%, yellow ('needs work') if 70%-89%, orange ('at risk') if 40-69%, red ('behind') if 2-39%, and blue ('not started') if <2%.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!