How to Have Children Rows Updated based on Data from Parent Row

CathyP712

I am setting up a sheet which will have many parent rows with many children connected to them. There is a column called "Escalated to AM?" which is a drop-down with the option to select "Escalated". There is another column called "Escalated?", which is a checkbox column.

I want to add a formula to the "Escalated?" checkbox column, so that if the PARENT line has "Escalated" selected in the "Escalated to AM" column, then that parent row & all connected children rows all have the flag checked.

Is there a column formula I can set up for this?

CathyP712

Ah I figured it out. Here is the formuka

=IF(OR(PARENT([Escalated to AM?]@row )="Escalated",[Escalated to AM?]@row ="Escalated"),1,0)

This combines a formula tor checking the box if the row itself says "Escalated" (so the parent line can be checked)

=IF(PARENT([Escalated to AM?]@row ) = "Escalated", 1, 0)

With a formula for checking the box if the PARENT row says "Escalated"

=IF([Escalated to AM?]@row = "Escalated", 1, 0)