Help

Re: linking a column total to another table

232 0
cancel
Showing results for 
Search instead for 
Did you mean: 
BRIGITTE_BARIL
4 - Data Explorer
4 - Data Explorer

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! 

 

4 Replies 4

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. 

Mike, Consultant @ Automatic Nation

BRIGITTE_BARIL
4 - Data Explorer
4 - Data Explorer

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. 

 

Hey @BRIGITTE_BARIL!

I wanted to follow up in the above, and get to know if your need was finally solved :). 

Best,

Mike, Consultant @ Automatic Nation

BRIGITTE_BARIL
4 - Data Explorer
4 - Data Explorer

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