Set a status based on the children

Andrea_FCN

I have a status column that is a drop down single select data fields that displays status I would like the parent row to set automatically change to "Complete" when all the child rows are marked "Complete". Any idea

Genevieve P.

Hi @Andrea_FCN

You can uses a COUNT Function with the CHILDREN Function to count how many Child rows you have listed (using the "Task Name" column or Primary column)

COUNT(CHILDREN([Task Name]@row))

then use a COUNTIF Function to count how many Child rows you have in this current Status column that say "Complete".

COUNTIF(CHILDREN(), "Complete")

If the Counts are the same, you can return the word "Complete".

=IF(COUNT(CHILDREN([Task Name]@row)) = COUNTIF(CHILDREN(), "Complete"), "Complete")

However we have no other instructions in this formula. This means that until all the child rows say "Complete", you'll see a blank cell, is this what you want? If there's any other status or word you want the formula to return, we'll need to identify what the criteria is for that word.

Let me know if this makes sense or if you'd like any further help!

Cheers,

Genevieve

Genevieve P.

Hi @Andrea_FCN

You can uses a COUNT Function with the CHILDREN Function to count how many Child rows you have listed (using the "Task Name" column or Primary column)

COUNT(CHILDREN([Task Name]@row))

then use a COUNTIF Function to count how many Child rows you have in this current Status column that say "Complete".

COUNTIF(CHILDREN(), "Complete")

If the Counts are the same, you can return the word "Complete".

=IF(COUNT(CHILDREN([Task Name]@row)) = COUNTIF(CHILDREN(), "Complete"), "Complete")

However we have no other instructions in this formula. This means that until all the child rows say "Complete", you'll see a blank cell, is this what you want? If there's any other status or word you want the formula to return, we'll need to identify what the criteria is for that word.

Let me know if this makes sense or if you'd like any further help!

Cheers,

Genevieve

Andrea_FCN

Thank you your feedback was so helpful. Your right in that the field will be blank otherwise but now I have an approach and will try to figure out the rest.