nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Need formula to count starred items from a parent row.

Eric Shin

I'm looking to count starred children from a parent row.

I'm sure there's an easy way to do it by doing a: COUNTIF(CHILDREN(....

Any help is appreciated.

Find more posts tagged with

Healthcare

Formulas

Project Management

Comments

Andrée Starå

Hi Eric,

Try this.

=COUNTIF(CHILDREN(Stars@row); 1)

The same version but with the below changes for your and others convenience.

=COUNTIF(CHILDREN(Stars@row), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

How to show each child row item on a separate line in a generated PDF?
Hi! I’m trying to create an invoice using Document Builder. I saw a video where they had a parent row with child rows underneath, and the child row items appeared in the generated invoice as separate lines. In the comments, they mentioned that Document Builder only generates from one row, so the child row data needs to be…
How to set up a rule depending on what is selected in a previous column
How can I set up instructions from an earlier coloumn, if someone has selected Bonus A this means that a payment is due 6 months after the start date so need to show this date in the column
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…