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!
Is there a way you can "lock" a specific filter on by default for a sheet you publish to a dashboard? I'd like to have the sheet editable from the dashboard, but I'd like it filtered to "current user" so it can act like a one-stop shop for everyone to review the reports and update the sheet at once. I have one filter on…
Hi fellow community members, Have raised a support case for this problem, but wanted to get a feel for if anyone else in the community has experienced this (or can reproduce it): Use mobile app → open a sheet → select Mobile View (using the selector at the top) → tap into a cell → select the icon that indicates you want to…
I'm dying over here! I have tried this formula countless times and #unparesable keeps populating. I am trying to calculate thew amount of days between 2 dates. My column name is Date and Date Complete. I created another Column titled Days to Complete. This is my formula. NETWORKDAYS([Date], [Date Complete], [holidays])…
