If formulas with Parents & Children

Marvin Paisley

Hello All,

I have been looking for some help with a formula between parents and children.

The goal is to have a column to pull a report off of so when it pulls we know it was a child and not just a regular line.

The formula works for a Child but when we want the Parent line in the column to pull the parent data it shows up as "blank". We have part of the formula going off an ancestor column (Labeled in photos as the Parent column), so maybe that is where we are going wrong?

Formula is as follows that works only for children: =IF(COUNT(CHILDREN([Equipment/Project Title]@row)) = 0, PARENT([Equipment/Project Title]@row))

We have tried a couple different formulas but it still won't pull the parent title.

Thanks in Advance!

Paul Newcome

You have an output for if it is a child row, but you didn't include an output for when it is not a child row.

=IF(COUNT(CHILDREN([Equipment/Project Title]@row)) = 0, PARENT([Equipment/Project Title]@row), this is where you tell it what to do on the parent rows)