I’ve searched the community for a similar solution but couldn’t find anything that worked for me.
Here is the sample document I’m working from: https://coda.io/d/Untitled_d_g5cBWgYSv
Basically I have a company, contacts and deals table.
Each contact has a company ID assigned from the “Company” table.
In the deals table, I want a column that shows for each deal, the list of contacts associated to the company for that deal in a format “Name (Email)”. This would be in a bulleted list or similar.
Is this possible to achieve? I tried experimenting with the Filter function but had little success.
Any help is greatly appreciated.