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.