Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 15, 2019 09:44 AM
Hi, sorry in advance if this has been asked for. What I’m trying to do is reference a cell and lock it into a formula similar to how in excel you would do the following for example;
=A1*'TAB2!$A$2
Thanks,
Aug 15, 2019 02:06 PM
Welcome to the community, Kevin! :grinning_face_with_big_eyes: Unfortunately Airtable, being a database, doesn’t support direct cell referencing like a spreadsheet does. If you have a link field, though, and have a link in that field that points to a specific record in another table, you can then use a lookup field to retrieve the data from any other field in that linked record. It’s not as free-form as a spreadsheet, but still very useful in the right circumstances.
Could you describe more about the setup you’re trying to achieve (more at a conceptual level, not at the specific table/cell level)? We may be able to offer some ways to optimize your base.
Aug 16, 2019 12:03 PM
Thanks for replying back Justin. Here’s what I am trying to achieve.
Tab 1 - I have a list of products with unit cost for each specific country ( rows). There are multiple countries listed (Columns) in this tab.
Tab 2 - Each country is assigned a value.
on Tab 1, I would like to reference the value assigned to each country on Tab 2 and multiply it to the unit cost of each product in that country on tab 1. I looked into linking the the cell together but I believe that was only for non numeric columns if I’m not mistaken. Let me know if this is clear enough so I can explain better.
Aug 16, 2019 01:35 PM
I created the following base . Please let me know if you are looking in that direction.
Neal