How to utilize a Checkbox with multiple Options


I know this is really simple but clearly it is Friday and my brain is no longer working.

I am trying to have a checkbox automatically check if the Finding is "Non-Compliant" or "Partially Compliant". I am able to get the functions to work when just choosing 1 option but when I combine it does not.

=IF([Finding: C/PC/NC]2 = "Partially Compliant", 1, 0)

=IF([Finding: C/PC/NC]2 = "Non-Compliant", 1, 0)

Please tell me how to combine the formulas that either outcome will check the box.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!