# 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!

• ✭✭✭✭✭✭
Options

Are you able to provide some screenshots of the rows that show each of the different colors (including the missing yellow)?

• ✭✭
Options

I had a coworker help me get it right, and this was her answer:

Ok, I think I got it. I think the issue was that we had the logic out of order. We want the red condition first, then yellow, and then default to green. Let me know if this works, if not we will work until we find the right solution! I’m happy to chat about it either way, if you would like.

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

• ✭✭✭✭✭✭
Options

The way the logic reads should work, but the way the logic in the first one read I thought should be working as well.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!