Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Adding up numbers from another table based on multi selection of records

Topic Labels: Formulas
2133 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, Newbie here and not good at code, hope you can help.

I have 2 tables, there is a lot more to the tables that is not relevant so I have presented a simplified version just to explain what i need.

1st table has 2 columns a list of containers in the 1st and how much is in each container in the 2nd

2nd table has 3 columns, in the 2nd column i can select multiple containers from the 1st table in a single box, 3rd column i want it to display the total contents of the selected containers in the previous box.

example Table 1
1 cont1 50L
2 cont2 175L
3 cont3 25L
4 cont4 50L

example Table 2
1,3 75L
2,4 125L

Hope this makes sense

Cheers
Vince

2 Replies 2

The basic functions you will need are a linked-record field, a Lookup field and another formula field to sum up that Lookup field.

In you 2nd table, the linked-filed will be where you select the multiple containers from the 1st, and everything will build off of that in the end table.

Hi,

Thanks for that. A rollup has sorted it.

Thanks