Column Formula IF Parent THEN formula ELSE text

I'm trying to create a column formula that will run a formula if the row is a Parent but let me add any value if it is a child

This gives me a #CIRCULAR REFERENCE error on the Parent and #BLOCKED on the children

=IF(COUNT(ANCESTORS()) = 0, AVG(CHILDREN()))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!