Formula % checked boxes in row

Anja Smeets
Anja Smeets ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have 5 check box columns in a sheet and would like to show the percentage checked for the individual rows in the 6th column.

Column 6 should show 100% if all 5 columns in that row are checked, 80% if 4 columns in that row are checked, 60 % if 3 columns in that row are checked, etc.

What is the best formula to use?

Comments