IF OR Formula
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

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

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")))

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!