# Set a status based on the children

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

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

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

• 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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!