Which formula should I use and is this even possible?

Michael Hair
Michael Hair ✭✭
edited 07/23/20 in Formulas and Functions

I am trying to write a formula that will determine someone's risk level based off a number system. The risk level will either be 0, 1, or 2/3. I would like a formula that could take someone's answer to three "Yes" or "No" questions and add them together to show their risk level. The "No" would be worth 0 and the "Yes" would be worth 1. Is there a way I can make the Yes/No's worth those values and in turn add up using a formula in the "Risk Level" column? I could also change the Yes/No drop downs to a checkbox if that would be the only way for this to be possible.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!