IF OR Formula

Options

I’m creating a symbol field with colors red, yellow and green for risk level. But I have two different totals columns (because we’re either looking at two separate sets of factors to assess risk - we will have a score for either one factor or the other). So I want to write a formula that says IF Cell A or Cell B cell is >10, red; IF Cell A or Cell B is <6, green; otherwise, yellow.

This is what I have so far:

=IF(OR([FDP Findings Risk Score]@row > 10, [Risk Score]@row > 10), "Red", IF(OR([FDP Findings Risk Score]@row < 6, [Risk Score]@row < 6), "Green", "Yellow"))

My symbol cell will turn red or green according to my score, but not yellow.

Any help would be greatly appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!