Counting checkbox's for children without counting the parent

Screen Shot 2021-06-22 at 4.16.37 PM.png

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

Find more posts tagged with

Formulas

Automations

Conditional Formatting

Cell linking

Enhancement Request

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.