Hi, I’ve created a relation similar to the Employee Dictertory example but the relation is not returning the proper data. In addition to the columns found in Employee Dicterory example, I have added to 2 new columns Company Email (column A) and Company Name (column B). However, when I do the Manager relation it’s returning the Company email instead of the Name of the employee’s manager.
The relation column in the data tab is just going to show the first column from the related sheet. This is normal and the relation is still correct. If you are looking to return a particular column, from the related sheet, you will need to also create a Lookup column. The Lookup column uses the Relation to retrieve a specific column value from the related sheet.
Okay thanks Jeff. I was confused.