Lookup and sort information based on a lookup field in same table

[Eos_HR_Team]

I am trying to sort information for employee reviews in columns, but I;m not sure what tool I should be using or if it is even possible to do in Airtable. Here is the scenario:

I have a list of email addresses (column 1) and employees (column 2). In column 3, using a linked record to the email address, I have assigned people who will do peer reviews. Now I would like to add a column that shows all the employees assigned to the original employee (column 2).

Is this possible?

[Kamille_Parks]

Add a Lookup-type field that relies on the {Peer Review Assignment 2021} field that points to the `{Full Name} column (fastest way to do so is right click the link field and select “add lookup”).

[Eos_HR_Team]

Thanks Kamille, but that’s not exactly what I’m looking for.

Currently the Peer Review Assignment 2021 column are the people that have to do a review on the employee. I would like to add a column that shows all the employees that are assigned TO the employee in that row.

Using the names in the screen shot…Cecilia is assigned to do a review on Morgan, so on Cecilia’s row I would like to add a column that shows she is assigned to Morgan.

I hope that makes sense.
Thanks,

[Kamille_Parks]

Oh, sorry. You’re looking for a reverse link setup. That’s something handled automatically for links across tables, but as you’ve discovered not within tables.

I see you have the current year in your field name. Is this something you have to do each year? Will you be adding a new field for each year? That setup is going to complicate your options.

[Eos_HR_Team]

The year in the field names is not something that is required. I’ve used this database as a grand experiment in learning Airtable, so I’ve added the year to fields as I have made modifications.