Checkbox in Column if RYB is Red or Yellow, Not checked if Green in Risk Column

RGeet

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.

Michael Kingsbury

=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 

 

​

RGeet

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

Michael Kingsbury

No problem. Always good to have the functions page bookmarked!

 

https://help.smartsheet.com/functions