Get all Parents

yannickburkart

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?

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

yannickburkart

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.

Paul Newcome

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.

Andrée Starå

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

Sign in to join the conversation!

Quick Links

Trending discussions

Contact List showing as a text only
It happened suddenly. It was working last week. I'm using Index Collect to pull a contact as cross sheet reference. But today, I did not see that working well. Usually it has circle beside my name, suddenly it vanishes, and it just contains text. I'm using those other columns to be sent notification, and it doesn't work…
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…