Get all Parents
I tried to count all parents inside a sheet but since now it was only possible with an additional column.
The formula I used to check if it was a parent is this one: =IF(COUNT(PARENT([Task Name]2)) > 0, "false", "true")
And to calculate how many parents are existing, I just counted the cells, where the value is "true"
My question is: Is it possible to count all Parents without using an additional column?
Comments
-
Hi Yannick,
Yes, but it depends on your specific sheet structure. If you have a top parent with all "parents" children underneath and only one level, it will work with something like this.
=COUNT(CHILDREN([Task Name]1))
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Not quite what was I was looking for, but thank you very much anyway.
I have to check on one sheet if it is a parent, if yes, I need to count them depending on the value in another column. The result should be displayed in another sheet.
It works, if I first check in the sheet if each row is a parent or not and afterwards I count where the cell content is true (for parent) but I try to get rid of the column where I check if the row is a parent or not. (I hope you understand what I try to do)
But as I said, I am very thankfully for your comment.
-
You will need to leave the column where you check if it is a parent row or not. If you don't want it to be visible, you can right click on the column header and select "Hide Column" from the dropdown menu. This will allow you to continue running accurate calculations while also keeping your original sheet organized.
-
Happy to help!
Could you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!