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!

Count If Children

Tony Barthelemy

Good Day All:

I am trying to count the Children and grandchildren in my Status Column that meet a specific criteria. Currently its counting the parent and grandparent in that column

Current formula: =COUNTIF(Status:Status, "Ahead")

Thanks

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Kam,

Have you tried the new DESCENDANTS function?

More info: https://help.smartsheet.com/function/descendants

Try this.

=COUNTIF(DESCENDANTS(), "Ahead")

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Tony Barthelemy

That worked, thanks!

=COUNTIF(DESCENDANTS(Status1), "Complete")

Andrée Starå

Ok.

Can you maybe share the sheet(s) or some more screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Tony Barthelemy

I found the error and it worked perfectly.

Thanks

Andrée Starå

Excellent!

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Formula To Set Urgency Based On Multiple Criteria (Fields)
Hello, I have a sheet that lists requests, and I want to write a formula for the Urgency field (Critical, High, Medium, Low dropdown options). Estimated End Date Actual End Date Users Affected Work Blocked Users+Blocked Urgency Status 06/19/26 06/12/26 15 No Completed 06/11/26 17 Yes ! Critical In progress 06/15/26 5 Yes…
Count Blanks from Referenced Sheet
Hi all! I am attempting to count the Blank cells in the 'Assigned to' column of another spreadsheet and have it not include the blank cells at the bottom when the rows are also blank. This is the formula I'm using now, but it is counting those blank cells/rows at the bottom of the reference sheet: =COUNTIFS({Deposit…
Formula broken on one sheet but not broken on others?
Hello Smartsheet Community! I have a formula that is acting up on one of our sheets. We use a budget sheet that is standardized across multiple Business Units and one of the sheets is currently throwing an #INVALIDVALUE error with the below formula. =IF([PO or CC]@row = "Purchase Order", SUMIF([Salesforce…