Parent and Child Status Formula

Calum Miller

Hi,

I'm hoping to create a Formula in my parent row to state if both child row's marked as complete then Parent row will automatically mark as Complete.

Is this possible?

Thanks!

Bassam Khalil

Hi @Calum Miller

Hope you are fine, the following formula will work with you whatsoever the count of the children under the parent (if All child row's marked as complete then Parent row will automatically mark as Complete), please try it.

=IF(COUNTIF(CHILDREN(), "Complete") = (COUNT(CHILDREN())), "Complete")

Bassam Khalil

Hi @Calum Miller

Hope you are fine, the following formula will work with you whatsoever the count of the children under the parent (if All child row's marked as complete then Parent row will automatically mark as Complete), please try it.

=IF(COUNTIF(CHILDREN(), "Complete") = (COUNT(CHILDREN())), "Complete")

Calum Miller

Hi Bassam,

Thanks for reaching out!

It did! However, I was wrong in how I wanted it to work;

What I actually want is to be able to the status column in Parent row to represent the overall status of all child rows.

For example if all child rows = Not Started the Parent Row would = Not Started, however if one of child row = completed, and other two in progress, Parent row would = In progress

Is that possible?

Thanks!