What I’m trying to do
I have a base with 40 notes, let’s call them “Award Show 1”, “Award Show 2”, and so on for the sake of the example. Each note has multiple categories of awards listed as properties, and each property is a list linking to the names of individuals who won that award that year. I’m looking to make it so that I can make a base of all the winners and include a column listing what awards they won (and which show they won that award on, if possible).
Example of what the notes look like:
Award Show 1
category-1:
- '[[Winner-1]]'
- '[[Winner-2]]'
- '[[Winner-3]]'
category-2:
- '[[Winner-4]]'
Then, the base would be a list of the winners, and I’m looking to add a column that would list [[Award Show 1]] in that column in [[Winner 1]]'s row.
Things I have tried
I have found a thread that seem to be kind of related to what I’m talking about and I’ve tried plugging in my properties to the solution here, but 1. It didn’t work and 2. I can’t really make sense of what OP is asking for, so I’m not able to make sense of which parts of the formula I could move around to make it correct for what I’m trying to do.