How do I count the number of parents in a column?

Marwan

I want to count the number of parents in a column, I am able to count the number of children and descendants using, =COUNT(CHILDREN([Primary Column]:[Primary Column])) and =COUNT(DESCENDANTS([Primary Column]:[Primary Column])). When I try to do the same to count the parents, =COUNT(PARENT([Primary Column]:[Primary Column])), I get an error. Any suggestions?

Paul Newcome

Are you able to provide a screenshot with some sample data and indicate exactly which rows you are referring to?

Andrée Starå

https://community.smartsheet.com/discussion/121272/how-do-i-count-the-number-of-parents-in-a-column

Hi,

I hope you're well and safe!

You could try adding a so-called helper column.

Try something like this. (Update the column names to match your own)

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!