Help

Returning multiple row headers based on match within one column, both tied to same base

Topic Labels: Formulas
187 3
cancel
Showing results for 
Search instead for 
Did you mean: 
hrath
4 - Data Explorer
4 - Data Explorer

Is there any way within airtable to return multiple row headers based on a column match? I have an example below. Basically my master base is company-focused but I have two fields "Investors" and "Investments" which would both be matching items in the "Name" field. Ideally I want to be able to tag "Investor(s)" in a column but have the "Investment(s)" column auto-populate pulling in "Name" based on a match of "Investor(s)" to "Name" in that particular row.

 

NameInvestor(s)Investment(s)
Startup AInvestor A, Investor B 
Startup BInvestor A 
Startup CInvestor B 
Startup DInvestor A, Investor D 
Company A  
Investor A Startup A, Startup B, Investor D
Investor B Startup A, Startup C
Investor C  
Investor D Startup D
3 Replies 3

Hi,

I can't clearly understand your goal, but it seems like on your place I would create 2 tables: 1st for Startups, linked to the second table of Investors. 

Hi,
Is this one table in your Airtable base?  If so, it should be 2 tables.  First table named Investments where Name is "Startup A", Startup B", etc.  Second table named Investors where name is "Investor A", "Investor B", etc.  Your Investor(s) field in the Investments table should be linked to the Investors table.  

Feel free to book some time with me to discuss additional ways I may help.  My Calendly link is:  https://calendly.com/d/zvr-vqp-j95/30-minute-meeting

So, with reference to the row "Investor A", you'd want the results:

1. Investor A - Startup A
2. Investor A - Startup B
3. Inverstor A - Investor D

Is that right?  If so, you could accomplish this with a formula field with`SUBSTITUTE()` replacing commas with the "Name" value