Relations view when using sheets

I am using sheets as the data source, I am able to create a relation based on foreign keys. I am struggling to get the view to display a field using the relation.
This is the data:

This is the view which isnt showing the relation column:

I would like the list to use the job title based on the matching job_id

Please help in this regard, All suggestions are greatly appreciated.

Relations are links to entire rows of data. If you want to pull a specific column value out of that relation, you also need a Lookup column that uses that relation.

1 Like

You’re a lifesaver dude. TX a ton!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.