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 need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
