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?

 

 

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

  • yannickburkart
    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 Newcome
    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å
    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

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!