Automate RYG Balls

bmangam456
edited 12/09/19 in Smartsheet Basics

Hello! I am trying to automate the cells so that when a specific value is entered, it will return a colored ball in the same cell

Example: 0 = Red ball, .6= Yellow Ball, 1= Green Ball

and

0%-30%= Red, 31%-70% = Yellow, 71%-99% = Green, 100% = Gray

Can you please let me know how I can achieve this?

Thank you

Comments