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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!