Checkbox Formula

JDuncan · 02/09/18

Hi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes that have been checked off versus the total number of check boxes (ex. Scores Received: 4 out of 20)

Can someone provide a formula? Thank you!

Andrée Starå · 02/11/18

Hi,

Here's one way to do it by counting the children.

="Scores Received: " + COUNTIF(CHILDREN(Check); 1) + " Out of " + COUNT(CHILDREN())

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Checkbox Formula

Comments

Help Article Resources

Categories