Count the number of projects done for a client without sub projects

I'm trying to count the number of projects completed for a client. I've changed the client name to Apples for confidentiality purposes. I want to count the number of projects done for Apples, without including the indented rows. Screenshot below:

I have tried the following formula: =COUNTIF(DESCENDANTS(Client:Client), "Apples"), however, the result comes back as 7 rather than 5. Any solutions?

Find more posts tagged with

Formulas

Accepted answers

All comments

John Jonassen

I think you want to use CHILDREN rather than DESCENDANTS.

Is there a value of 2 next to the one Apples that is furthest indented?

Sareena

Hi John,

Tried that, gave a result of 6.

John Jonassen

Are you able to provide a wider screenshot that shows the values for each row?

Sareena

Hi John,

Sure,

John Jonassen

Ok, I see what is being done now. You are referencing the entire Client Column, since there is no real hierarchy when you reference an entire column, it will treat them all as Descendants or Children.

That being said, if you are trying to get your formula to work in the Project/Prop...Code column, try this where it currently has the "1" in the dark blue bar.

=COUNT(Children())

Sareena

Hi John,

Thanks! This worked! Such an obvious solution!

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.