Help with the following parent/child formula

=COUNTIFS(CHILDREN([Not Applicable]@row), 0, PARENT([Name of the Operational Provision or Rule],"Payer-Accounts")

#INCORRECT ARGUMENT SET

I am trying to count child rows where a checkbox is set (not applicable) where the parent row title is "Payer-Accounts". I am creating individual Summary values for each of the parent rows.

I don't need the formula in the smartsheet (I have it there now to try to create one that works). I'm guessing that's why it has @row, however, in the summary I'll have a field for Payer-Accounts Count and it should provide a count of the child rows.

Do I need Payer-Accounts to be on each of the rows as well, if so, it is included in a hidden column named Workstream, but then it would count the parent row as well wouldn't it?

Find more posts tagged with

Formulas

parent row

Accepted answers

Paul Newcome

You need to first insert a text/number helper column (called "Parent" in this example). It will use the following formula to pull parent row data onto all child rows:

=PARENT([Name of the Operational Provision or Rule]@row)

Then you sheet summary field would be:

=COUNTIFS(Parent:Parent, @cell = "Payer-Accounts", [Not Applicable]:[Not Applicable], @cell = 1)

All comments

Mark.poole

@jgryniewicz

This can be achieved by

=COUNTIFS(CHILDREN(Parent row AND COLUMN), 1)

jgryniewicz

Thank you @Mark.poole but consider me completely ignorant :O That didn't work if I pasted literally. I'm assuming I have to add a reference somewhere… am I replacing "Parent"?

Paul Newcome

You need to first insert a text/number helper column (called "Parent" in this example). It will use the following formula to pull parent row data onto all child rows:

=PARENT([Name of the Operational Provision or Rule]@row)

Then you sheet summary field would be:

=COUNTIFS(Parent:Parent, @cell = "Payer-Accounts", [Not Applicable]:[Not Applicable], @cell = 1)

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.