Help with the following parent/child formula

jgryniewicz

=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?

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)

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)