I want to get a count of how many rows & % have been checked in a sheet (no parents or child rows)
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
Answers

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))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!