Checkbox in Column if RYB is Red or Yellow, Not checked if Green in Risk Column
Hello,
I am new to using formulas and am struggling with trying to automatically check a checkbox in one column if, in the Risk column, the RYG risk is red or yellow, not checked if risk is Green. I am able to get the following formula to work for red and yellow:
=IF(OR(Risk1 = "Red", Risk1 = "Yellow"), 1, 1)
I am not able to get the following formula to work with the green condition added (it comes back as "#unparseable"):
=IF(OR(Risk1 = "Red", Risk1 = "Yellow", Risk1 = "Green"), 1, 1, 0)
Any guidance is much appreciated.
Comments

=IF(OR(Risk1 = "Red", Risk1 = "Yellow", Risk1 = "Green"), 1, 1, 0)
You have one to many conditions. So it should be.
=IF(OR(Risk1 = "Red", Risk1 = "Yellow"), 1, 0)
AKA if Risk1 is Red or Yellow then it will be true otherwise false.
False condition will be for Green.
Let me know if that helps!
Michael

Thank you so much Michael! That did the trick and I learned something regarding formulas.

No problem. Always good to have the functions page bookmarked!
Help Article Resources
Categories
Check out the Formula Handbook template!