Populate a Parent Cell based on the children cells beneath it

Josh Tyler

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.

Mark Cronk

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

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

Work?

Mark

Mark Cronk

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

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

Work?

Mark

Josh Tyler

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

Josh Tyler

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?

Josh Tyler

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

Mark Cronk

Hi @Josh Tyler ,

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

Mark

Mark Cronk