Help with IF formula

Helen Coen
Helen Coen ✭✭✭
edited 04/10/23 in Formulas and Functions

Struggling to write an IF formula and looking for some help please. Needs to work as follows:

If a cell is showing a number between 0-2, "Blue", if between 2.1-4 "Green", if between 4.1 -5 "Yellow", greater than 5 "Red"

Help appreciated

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!