I want to get a count of how many rows & % have been checked in a sheet (no parents or child rows)

Jade Ranes

I want to get a count of how many rows have been checked in a SmartSheet and then what is the percentage of the total number of rows that have been checked. No parent or child rows involved.

For example I have a SmartSheet with 228 row, I need to know how of those rows had had 1 particular column checked and what is the overall percentage of rows checked.

Jade R

Paul Newcome

You would count how many are checked and divide that by the total number of rows.

=COUNTIFS([Checkbox Column]:[Checkbox Column], @cell = 1) / COUNTIFS([Checkbox Column]:[Checkbox Column], OR(@cell <> 1, @cell = 1))