Filtering or looking up across multiple columns

1

Hi all, I am trying to filter or lookup across multiple columns. I have a “teams” table with people assigned to various team, and I want to show what teams people are assigned to in the “people” table.

See this example doc for what I am trying to do.

Searching the forum I found this approach, but people were not jazzed about it. Is there a better, more flexible way?

Screen Shot 2021-08-23 at 7.49.02 PM

3

Hi @Robin_Bigio :blush:

I have this formula

Teams.Filter(
  ListCombine(
    [Product Lead],
    [Designer Lead],
    [Eng Team]).Contains(thisRow)
  )

… which should gets you to the same results without the need to use OR :blush: .

Not sure if that’s much more flexible though as it would still require to modify the formula if or when you add more teams :blush:

4

Thanks @Pch, that helps :slight_smile:

5

No problem :grin: !

I’m glad to know it helps :grin: !