If statement in parent row to delete children row?

cgnzlz22

I am working on a sheet where a task is to validate a set of data. If the data fails there is a follow up task to revise, if it passes the next task is to launch. Right now I have these all set as rows.

But I wanted to see if there was a way to insert a checkbox for pass/fail and then based on whether that pass or fail checkbox is checked the proper next step is shown and the other step is deleted/hidden/blacked out.

Ideally once you select the checkbox one of the children tasks would be deleted like below picture.

Second option would be, once checkbox is selected, the task not pertaining to the checkbox, gets blacked out

Any thoughts? Not sure if this would be a formula (IF statement (which I am not so good with)), or some sort of workflow, or if I am just reaching too far here.

Thanks in advance!

Paul Newcome

If they are both the same dates/duration, then you could use a formula in the [Task Name] column.

=IF(PARENT(PASS@row) = 1, "Launch", IF(PARENT(FAIL@row) = 1, "Revise File", "Data Validation Incomplete"))

cgnzlz22

I thought this worked but it seems it always reverts to output "Revise File" no matter what checkbox is checked 😕

Any thoughts?

Paul Newcome

Exactly which cell are you putting this in?

cgnzlz22

Paul Newcome

In your screenshot it should output "Revise File". Here is how your formula reads:

If the cell in the parent row of the PASS1 cell is checked, output "Launch". If the previous is false and the cell in the parent row of the FAIL1 cell is checked, output "Launch1". If both are false, output "Revise File".

Try copying my formula exactly including "@row".