Join two sheets automatically

Support
1

Hi,

I have a sheet of employees
Employee ID
Name

and another with tasks
Task ID
Employee ID
Task

Is there a way to automatically create an inner join table on a separate sheet with these fields, using Employee ID as the joining field? This table should update itself any time there’s an entry on any of the tasks table.

Employee ID | Name | Task

2

Hi,

You could directly create a field Name on Task sheet, and set link and load on it.
Employee ID would be linked field and new field Name would be loaded field.