Parent Child formula for Checkboxes

Hello,

I am working on a checkbox column formula for a sheet that will function as a roll up but will not automatically check the lowest children.

Currently I have this:

=IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN(Tasks@row)), 1)

That formula works, but you have to manually add it to each parent row. I would rather have something that I can set as a column formula instead if it's possible. Anyone able to help expand the above to what I am looking for?

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @Mross0878

If you set your column to be a column formula, then you won't be able to manually add data to any of the cells (as they will be locked to the formula.

You could put that same formula in a new, separate column, perhaps with an addition to make it blank if it's a child cell:

=IF(COUNT(ANCESTORS(Tasks@row)) > 0, "-", IF(COUNTIFS(CHILDREN([Checkbox Column]@row), 1) = COUNT(CHILDREN(Tasks@row)), 1))

Note that you'd need to reference your current column in your Count-Children part of the function. Does that make sense?

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Mross0878

If you set your column to be a column formula, then you won't be able to manually add data to any of the cells (as they will be locked to the formula.

You could put that same formula in a new, separate column, perhaps with an addition to make it blank if it's a child cell:

=IF(COUNT(ANCESTORS(Tasks@row)) > 0, "-", IF(COUNTIFS(CHILDREN([Checkbox Column]@row), 1) = COUNT(CHILDREN(Tasks@row)), 1))

Note that you'd need to reference your current column in your Count-Children part of the function. Does that make sense?

Cheers,

Genevieve

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.