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!
