How do I use IF formula to change a colour based on a percentage column?


I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage.

i.e. 1-50% Red

51%-99% Yellow

100% Green



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!