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 have Timesheets and would like to create Invoices. Right now I have 2 sheets, Timesheets and Invoices. One person can have multiple timesheets for the month. Can I move cell contents from 3 Timesheets into one row on the Invoice? I have tried a Join/Collect but it is only capturing one row. Thanks!
Using a VLookup I was able to get the budget manager column to return the multiple values based on the paying department. However, I also need it to return another person if the grant option is selected. The budget manager column on the first sheet is used for a filter on a dynamic view to allow only the contact and budget…
I'm trying to set up a formula to calculate merit increases but, I keep getting "#UNPARSEABLE" in my cell. Can someone tell me what I am doing wrong? thank you! =if([Salary Per]@row ="Hourly",[Proposed Hourly Rate]@row *2080, if([Salary Per]@row ="Annually",[Current Salary Rate]@row *(1+[Increase Percentage Salary]@row…
