Formula to capture % of boxes not checked

For new hire training there are several items they must complete for training requirements to be met. I am trying to figure out a way to show % uncomplete for all open training items (boxes in red that are not checked). Is there a formula to capture % not completed for the entire grid and then a % not complete for each row (employee)?

Tags:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!