Layering links to records

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.