Creating a percentage from multiple tick boxes

Hi All,

This may be simple but i'm struggling to get an output so hoping you can help...

I'm trying to calculate a percentage based on the number of completed tick boxes in a row/column.

I'd be ok if this initially does a count in one cell and then coverts to a percentage in another. This is the example data below:

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!