# Populate a Parent Cell based on the children cells beneath it

✭✭✭

We are doing testing. The parent row is the name of the scenario we are testing. In the result cell I would like it to populate pass, or fail based on the steps (children rows) below. For example if step 6 fails, the tester changes the result to fail, I would like it to automatically change the parent cell to fail. And if all the steps pass I would like the parent cell to populate as pass.

Is there a formula for that? For example if the grey row failed, the cell that has "Not Started" would change to fail, or change to pass if all the steps passed.

• ✭✭✭✭✭✭

Good evening,. Place this formula into your parent rows:

=IF(COUNTIF(Children(), "Fail")=0, "Pass","Fail")

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Good evening,. Place this formula into your parent rows:

=IF(COUNTIF(Children(), "Fail")=0, "Pass","Fail")

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭

OMG - You are stinking AMAZING!!!!! If I could I would hug you! LOL

This is exactly what I was racking my brain on yesterday! THANK YOU 1,000,000,000 yes a Billion times!

Someone get this guy a prize :-)

Josh

• ✭✭✭

Sorry Another question. How can we modify the formula to read Not started if all the (children are blank) ...meaning we have not started the test yet?

• ✭✭✭

Figured it out:

=IF(COUNTIF(CHILDREN(), "Blocked") > 0, "Blocked", IF(SUM((COUNTIF(CHILDREN(), "")), COUNT(CHILDREN())) = COUNTIF(CHILDREN(), ""), "Not Started", IF(COUNTIF(CHILDREN(), "Fail") = 0, "Pass", "Fail"))) Saw another Post from @Mark Cronk and was able to figure out this one.

Thanks All

• ✭✭✭✭✭✭

Hi @Josh Tyler ,

Glad you found solutions. Thank you for contributing to the Community.

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.