Need a Formula that only applies to Parent rows

I am trying to figure out a formula that will only apply to parent rows. I want the Parent % complete to calculate on the total percentage of all child rows. The embedded formula depends on a duration, and I do not want that.

The current formula I have is this:

=IF((COUNT(CHILDREN(Primary@row)) > 0),AVG((CHILDREN([% Complete]@row))),([% Complete]@row))

I'm not sure what the second part of my if statement should be, since I want it to be whatever % has been entered for the Child row.

I was hoping to also make this a column formula to apply to all rows, but not sure if that is possible.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!