Get all Parents

04/03/19 Edited 12/09/19

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?

 

 

Tags:

Comments

  • Andrée Starå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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • edited 04/03/19

    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 NewcomePaul 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.

    thinkspi.com

  • Andrée Starå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, [email protected])

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.