How to combine if/or statements



I am trying to create a formula so that if days open is >=4 color turns red, if days open is >=2 color turns yellow or color is otherwise green OR if the resolved column is check the color is green

I am trying to combine the below two formulas but can not seem to get it right.

=IF([Days Open]@row >= 4, "Red", IF([Days Open]@row >= 2, "Yellow", "Green"))

(OR [Resolved@row=1, "Green"])

Thanks for any insight!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!