Using Multiple Checkboxes to determine and auto-update % Complete

I have some tasks for an implementation Smartsheet that require different steps. I would like the % Complete column to auto update to 33%, 67% or 100% based on the boxes checked. Obviously if the final box is check it would be the 100% and ignore the 2 boxes that came before it. I attached a screen shot with the formula I attempted but it does not work. Any ideas? Also not sure if the true result should be 33 or .33 if the entire column is set up in % format.

2020-06-03 10_27_00-TL & EP New - Smartsheet.com.jpg


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!