Check all child rows under a specific parent row (or several specific parent rows)

Carson Starnes

Hello :)

I have a check box column to track if a property is a rental property or not. There are several parent rows in the sheet with different real estate programs. The parent row programs will either contain all for sale properties or all rental properties. How can I create a column formula that automatically checks the box of all children under the parent rows that are rental programs (they all have different names)? This way when new rows are added to the sheet, their box will automatically be checked or not checked depending on which parent row program they are subordinate to.

Alternately, how to I create a column formula to automatically check every box underneath the "Rental - Single" parent?

Thanks!

Erika Sajdak

You could use something like this

=IF(PARENT([Column2]@row) = 1, 1, 0)

Where column2 is the checkbox in the child row - and then make it a column formula to incorporate any and all parent rows.