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
 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!