Hi, I am creating a life project tracker in which I have multiple layers of records so I start with
Within “Investing” I have 3 “Subgroups”:
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?