Hello,
Say I have these two tables, “Directory” and “Company”.
I’m needing a formula for the Company table’s “Employee Summary” column. I’m just wanting the row to look up and list the employees that are assigned to that company in the “Directory” table (the ‘Coke’ row should list John & Eric, and so on).
I’m driving myself crazy trying to figure this out. Many apologies as I know the answer is bloody simple, but I’ve tried every formula under the sun and can’t get it working.
Thanks a ton.
@Sarah_Arminta Thank you SO MUCH! This is sincerely appreciated. That’s exactly what I needed. Appreciate your time.
I can’t say I fully understand why it works. This is the formula, correct?
Directory.Filter(Company.Contains(thisRow))
Does this formula output employees because that is the display column in the Directory table?
Yes, I believe that is correct. So we are filtering the Directory table and spitting out whichever records (employees) have a Company property that matches the Company of our row in the Company table.
Great to know. Thanks so much again. Happy Holidays!
As always in CODA, there are multiple ways to do this. This one eliminates the need for an extra table: Use the Directory table, and use options to group it on “Company”.