Counting checkbox's for children without counting the parent

Natasha Henman

OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this?

If the "Is there a color image?" box then the row will be counted.

My goal is to have a total count of images that we have a color version for. the URL is on a row of its own and when every child is checked under each URL then the URL checkbox is checked. I want to count all the checked boxes except for the URL checkbox, I want to know the total amount of images as well (checked or not) and I would love to see a percent of what has been completed

Bassam Khalil

Hi @Natasha Henman

Hope you are fine, did you mean you want the following:

1- count all checked boxes at child rows level only.

2- count all rows at the child rows level.

3- calculate the percentage of the checked child against the total child rows

Natasha Henman

@Bassam Khalil Doing good over here, and number 3 sounds the most like what I am doing. We want a way to see how many more images that we have left to find. When I have it count all the check boxes then it adds the parents checkboxes as well, which changes the number by about 300.