Parent Rows

Kirby Blackwell

Is there a way to remove the Start Date, End Date, and Duration from a parent row without Disabling Dependencies? 

We have an Alert set for the day after a due date in a column that has an unchecked Complete box. We are receiving alerts for our Parent columns which are not actual tasks. We could add a condition that the row has to be assigned to someone but then we will not be alerted if a row was accidently unassigned but still past due. It makes the most sense to remove these from the Parent column. 

 

Thank you.

Andrée Starå

Hi Kirby,

I'd suggest creating a helper column that would check a box if it's a parent row and then use that in the Alert to not trigger when it's a parent row.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I second Andree's suggestion. I actually use something quite similar to this rather frequently. 99% of my sheets have a checkbox column called "Parent" in them that checks the box for every parent row using a formula.

Kirby Blackwell

Thank you Andree! That will work! I'll have to go in and add it to 83 sheets but it'll work. 

Kirby Blackwell

thank you that works!

Andrée Starå

Happy to help!

Add the something like the below formula to a checkbox column. It will check the box if it's a parent row.

=IF(COUNT(CHILDREN()) > 0; 1; 0)

Hope that helps!

Kind regards,

Andrée

Paul Newcome

Happy to help.