How to write an if child, then parent formula?

Brent Eakins

I am trying to have the parent row flagged if the child row is flagged( at risk). I do not have much experience with formulas and I am really at a loss of what to do. Is there any one that can help write this formula and then explain how to apply it?

Heather Duff

Hi @Brent Eakins ,

In your parent rows, insert this formula into the flag column:

=IF(COUNTIF(CHILDREN(),1)>0,1,0)

This says that if there are more than 0 of the children rows flagged, flag; otherwise, no flag.

Let me know if it works!

Best,

Heather