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
Check out the Formula Handbook template!