Give a Rating of 100% if checkboxes with different conditions

Hello everyone, this is my first post and I hope I could get some help.

Im trying to create a formula with the following conditions:

100% rating if the YES chechbox is marked

100% rating is the N/A checkbox is marked

0% rating if the NO chechbox is marked


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!