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!
