Hi, I am creating a life project tracker in which I have multiple layers of records so I start with

“Broad areas”:

1. Health


2. Work


3. Investing

Within “Investing” I have 3 “Subgroups”:

A. Equities

B. Debt

C. PE

And within “Equities” I have 3 “Todos”:

i. evaluate long short

ii. rebalance portfolio

iii. set stop loss

I have a master sheet in which I have linked each broad area to its respective subgroup as a record, and they come up automatically when I add to either sheet. However, when I then link “Todo” to “Broad areas” in the same sheet, the cell doesn’t populate with the aggregated "Todo"s of all “subgroups” within a “Broad area”.

I.e. in my master sheet I want to be able to see

Investing in one cell → all the subgroups within investing in the adjacent cell (auto pop) → all the aggregated todos associated with ANY of the investing subgroups in the next adjacent sell

How can I make them autopopulate?

Thanks