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 formula disappears. Is there a work around? Can a column be both linked and be populated with a formula?
Thanks! Please let me know if you need more info