Linking tables with columns that have a formula

[Phil_Borreson]

I have a formula that produces a product ID in one table, I would like link that column to a single text column in another table. Can I create a column that is both a formula and is linked to another table?

[Roman_Scher]

In this case you should use a lookup field in your second table.

Once you create a linked field in your second table that links to records in your first table, you can then create a lookup field in your second table which looks up the product ID field from the first table.

[Octavio_Lopez_S]

Hello,

I don’t think what Phil wants to achieve is what Roman proposes.
May be this should be merged with this other post:

Formula with linked column? (i.e. two column categories) Apps

Hi All, I am testing if airtable will work better than excel. I have a “helper” column in my table that concatenates data from three other columns (ex: “date”&“city”&“person”). I would like to be able to use this helper to lookup data from another table (there are a finite number of “helper” strings, so the lookup table lists all of them and the corresponding return data). So I can use formula to create the string in the current table but when I change it to a link reference the concatenate for…

Or visceversa…