Help

linking a column total to another table

Topic Labels: Formulas
40 1
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! 

 

1 Reply 1
Mike_AutomaticN
7 - App Architect
7 - App Architect

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