Counting checkbox's for children without counting the parent

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

Answers

  • Bassam Khalil
    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

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • @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.

Help Article Resources