Calculate the percent of boxes checked from the number of rows populated

Buckwheat

Is there away to calculate the percent of boxes checked from the number of rows with data in them? But the number of rows with data populated will be different every time we import the data to the sheet.

J Tech

Hi,

In the sheet summary, create a new field / or use existing:

• Field Type: Text/Number

=COUNTIF([Checkbox Column]:[Checkbox Column], true) / COUNTIF([Primary Column]:[Primary Column],

Please replace field names with the names in your sheet.

Trust this is useful.

Buckwheat

I was looking to get a percentage of number rows populated / number of boxes checked in another column

J Tech

Thats ok,

=COUNTIF([Primary Column]:[Primary Column]/COUNTIF([Checkbox Column]:[Checkbox Column], true)