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
-
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
☑️ 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"
0 -
@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.
0
