Formulas

[Zara_Tai]

I want to set up a spreadsheet.

If I tick or x "residential accommodation" I would like the spreadsheet automatically tick dwellings, Residential Flat Buildings s etc also listed in the spreadsheet.

How do I do that in a formula or is there another way I can do it ?

[#2]

@Zara_Tai 

I'd add helper column C to mark manually and implement the logic in B by formulas