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

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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!