Help with lookups

4

I wouldn’t do 4 tables, just make effortview a view of the Members table.

[Task Assignments].Filter(
  [assigned to].Contains(thisRow)
).task.[Level of effort].Sum()

Summary of formula:
“If we look at all the tasks that have been assigned, filter down to just the ones that were assigned to this person (thisRow in Members table). Then, grab all the tasks that were assigned and their associated level of effort. Finally, sum all that up.”

1 Like