Formula link RGB Symbol to automatically update according to Number


Good Morning

I have another formula question, i was hoping i can get some help.

I would like to make the below RGB Symbol change according to the number below.

E.g. I would like the below yellow Symbol to change when the -0.2 number changes

The rules i would like to set are:

Green: 0 and above(anything positive)

Yellow: -1 to -10

Red: -10 and Greater


Best Answer


  • chris.italiano78351

    Perfect Connor, thanks heaps!

    Exactly what i wanted & appreciate the quick response 👍👍

    Stay safe

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!