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.

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

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

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



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