Hi, I’m trying to call information from multiple tables and collate them into one summary table, but I can’t seem to pull information from multiple tables into one table.
Here’s the set up I’m building for example:
- I have multiple products. Each product has its own table to track info everyday.
- I have a overview table that lists each of the product. I want to use this table to pull in info from tables from #1 (such as the last price).
So the way I’m trying to set up table #2 is calling each table in its own cell then using that reference to pull info:
Product | Reference Table | Summary Info
Product 1 | @table_for_product_1 | info pulled from Reference Table column
Product 2 | @table_for_product_2 | info pulled from Reference Table column
Product 3 | @table_for_product_3 | info pulled from Reference Table column
Hope that makes sense.
Unfortunately because I’m trying to call multiple tables, I can’t do a Lookup column type for the Reference Table column. I’m currently using the Text column type, which seems to only yield a link to the @table. So the Summary Info column isn’t working and I can’t call any info from the tables.
I also tried the Lookup() formula to no avail.
Thoughts on how to best go about solving this problem?