Hmm that's a weird one.  Once your records are linked up that should just work.  Could you provide some screenshots of your tables?  I've also set something up here for you to check out

Hello, 

thanks for getting back. 

I have attached two screenshots. In screenshot 1, "operations report" is the table I want to pull the information from and display in the other table (screenshot 2 "overview"). The columns "technical problems" and "comments operations"

You will see in screenshot 2 I have made a formula for the checkbox one as a work around and got it to display "yes" when there is a check mark in the original field. But I have had no luck finding a work around for the free text in "comments operations". As an example the content of that column might be "Equipment failed due to dinosaurs and butterflies. Operations delayed X hours". 

Hmm, and your lookup field doesn't have any conditional filters on it?  If you could provide a read-only invite link to a duplicated copy of your base with some example data I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable

Hello, 

If a "conditional filter" is the switches next to "Only include linked records from the Orders table that meet certain conditions" and "Limit the number of items shown" then no these are not on. I have attached screenshots of the set up boxes. 

I don't know how to make a duplicated copy with example data set up in the same way, or share it. Our system is massive and messy and I had no hand in setting anything up and I am new to airtable. 

Just to add, these views are both within the same table, not sure if that makes a difference

Hmm that looks fine!  Could you provide a screenshot of the "Orders" field for the record where the "Comments Operations" lookup is empty? 

Here's a guide on how to duplicate a base: https://support.airtable.com/docs/creating-a-new-empty-base

I am not sure what you mean, isn't the screenshot above "screenshot_comments operations_lookup" exactly that?

"Orders" is the name of the table both views are under.

Here is a link to the duplicated base. 

The view i am trying to get "Comments operations" to show up in is "overview for reports Rebekka".

The source view where "comments operations" is from is "operations report"

https://airtable.com/invite/l?inviteId=inv2E00gpg8IJg01b&inviteToken=a9ae6ce7b61b1a06ff5ac1f94b141007a2140d292d380a71c4cf7c3c86cf983c&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Thanks for the link!  I had a look and your setup's working fine, the record in question just doesn't have a linked record in its "Orders" field

Here's a screenshot of your base with the "Orders" field visible and you can see that the "Comments" lookup is working as expected:

---
Also, "Technical problems Rollup (from Orders)" takes the current record's value, and I believe you're trying to use the linked record's value?

Sorry I am not sure what you are meaning. The screenshot you shared is from the view that I am trying to pull information from. "Operations report" houses the info, I want to show it in a lookup in "Overview for reports Rebekka". The screenshot you are showing is from operations report?

I don't understand your wording with "current record value"?

Ah, that isn't the "Operations Report" view, that's just a troubleshooting view I created myself; views also don't affect how linked / lookup fields work!

I'd suggest checking out the following articles to get a better understanding of how linked and lookup fields work:

https://www.airtable.com/guides/build/connect-data-with-linked-records
https://support.airtable.com/docs/linking-records-in-airtable
https://support.airtable.com/docs/lookup-field-overview

Apologies if I've misunderstood what you're trying to do, and best of luck with it!

No problem, thanks for trying and all your effort, I will keep digging on my side 🙂