Percent of Checked Boxes

MTaylor

Struggling to come up with a formula to show percent of boxes checked.

Column Name = Task Complete

Column Type = Checkbox

Need to determine % of tasks complete (checked)

Gia Thinh

Hi @MTaylor,

The "Config Done" is a checkbox column, so expected value will be 0/1 (boolean) not a text value. So you should calculate your % of tasks complete (checked) in another text/number column or in a sheet summary field.

No need to use SUM, just modify your formula :

=COUNTIF(CHILDREN([Config done]1), 1) / COUNT(CHILDREN([Config done]1))

Hope it works.