Oct 31, 2024 03:33 PM
Hello!
I have a table that has multiple tabs.
If on Tab A, I have a column of costs, am I able to link the sum of that column to a cell on Tab B?
I know that I cannot use Airtable like I do Excel, but I am trying to do it anyway because I really love working on Airtable.!!
thank you for your help!
Oct 31, 2024 05:20 PM
Hey @BRIGITTE_BARIL!
I believe that by table you mean “base”, and by tabs you actually mean tables within the base :D!
Yes, you can have a linked field between the two tables. Link all records of Table A to a given record of Table B.
On Table B create a rollup, rolling up values from the linked record to Table A. Apply the SUM(values) formula in the rollup. That should be it!
Sorry for the lack of screenshots, I’m writing from my phone! Let me know if that somehow helps.
Nov 01, 2024 05:54 AM
Thank you for understanding my lack of proper terms!!!! I did mean Base and did mean tables in said base!!!
Your words read like what I am trying to do, now I will try to do it!!!! I may reach out for your help again! thank you very much.
Nov 02, 2024 08:25 PM
Hey @BRIGITTE_BARIL!
I wanted to follow up in the above, and get to know if your need was finally solved :).
Best,
Nov 03, 2024 07:24 AM
Not yet, I'm trying to work out how to use the function, looking at the tutorial online. Slow process but I'm sute I'll get there at some point