Parent rolling up data in Children rows

Green line is the parent row

everything inbetween is children rows

Column 30 is counting rows from N/A column that are not ticked, which are the rows im looking for. so 6 rows are active rows which are being used.

out of the 6 rows, 4 rows have been ticked in appoinment concluded column

i want to roll up the count of 4 in the parent column in column 31

is this possible?

would appreciate help from everyone or anyone. Thank you in advance!

@Paul Newcome @jmyzk_cloudsmart_jp I have tagged guys if you can help please?

Find more posts tagged with

Formulas

parent row

Accepted answers

Matt Lynn ACT

@Maz Uddin

Use this in your parent row:

=COUNTIFS(CHILDREN([N/A]@row), 1, CHILDREN(), NOT(ISBLANK(@cell )))

All comments

Matt Lynn ACT

@Maz Uddin

Use this in your parent row:

=COUNTIFS(CHILDREN([N/A]@row), 1, CHILDREN(), NOT(ISBLANK(@cell )))

Maz Uddin

@Matt Lynn-PCG it worked! thank you very much!

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.