I feel like I’m missing something, but I want to create a table that grabs some data from another table and I can’t figure out how to do it.
Table2: I’d like to have
The person column in the second table is a lookup to the first table. What I’d like is that the Manager field would automatically get selected based on the Person, but I can’t figure out how to do it. Lookups seem only for selection options not a fixed single value. I tried using formulas, but that is not behaving like I’d expect it to. (I tried [Table1].filter(Person=thisRow.Person).[Manager] but that gets me no results.