Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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
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
That worked, thanks!
=COUNTIF(DESCENDANTS(Status1), "Complete")
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)
I found the error and it worked perfectly.
Excellent!
Happy to help!
I am trying to extract information from the main sheet and create a report that calls out Garment Type in the date range of our FY.
We are getting duplicate notifications from our automations. These automations have been in place for over three years and have never done this before. There have been no changes made to any of them. This is happening on a variety of sheets and a variety of automations. It started sometime about mid August. Is anyone else…
I have been using the new Table instead of grid , I created a Dynamic View and I have noticed that it has lost all the formatting, whereas, when I have created a Dynamic View from Grid, the formatting remains.
