If formulas with Parents & Children

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!