Creating column with a filtered list from another ...

BenStucky

Hello,

Very new to AppSheets so thanks in advance for the assistance.

I have 2 tables - an Employee Table and a Teams table. In the Teams table it has an enum column that contains all of the Employees on that team. So Team{Employees] is a list of Employee[EmployeeID]s on that team. An employee can be on multiple teams. I want to know which teams an employee is on. So I want to add a column in the Employee table, Employee[Teams], that contains all of the Team[Name]s where the Employee[EmployeeID] is in the Team{Employees] enum list.

Steve

This?

FILTER(
  "Teams",
  IN([_THISROW].[EmployeeID], [Employees])
)

BenStucky

The output is the RowID value and not the name of the team. How would I get the team names?

Steve

This:

SELECT(
  Teams[Name],
  IN([_THISROW].[EmployeeID], [Employees])
)

BenStucky

I had tried that previously but I get the error "Extra content: "[Name]". Did you mean to separate it with a "," (comma)?". It's frustrating because that should be correct syntax.

Steve

Please post a screenshot that includes the entire expression and the error message.

Creating column with a filtered list from another enum column