RGB Balls IF Function on 4 Colours Rules

edited 12/09/19 in Formulas and Functions

Hello everyone, sorry if my grammar is bad. I am Chilean and I recently use Smartsheet, I have learned a lot in a short time. Now I need to solve this formula.

Grey =  IF Stock Column is “ “ (empty)

Red = IF Stock Column is “0”

Yellow = IF Stock Column <= Critico Column

Green = IF Stock > Critico Column

Could you give me a hand

(see image)


Captura de Pantalla 2019-08-12 a la(s) 21.11.18.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!