Skip to main content

I think what I am wanting to do is also possible with a rollup field. However, I can't get it to work.

I have a column that I want to add all the values on a different table.

 

Table 1 has all the prices in it.

Item 1 > Shoe > $39.95
Item 2 > Shoe > $39.95
Item 3 > Shirt > $19.95

 

I want to add all the "Shoes" together in Table 2 and display that total.

 

So I made a rollup field and said if the values in table 1 match "shoes" then "insert formula here"

I tried using SUM....but I am not doing something right. Am I overthinking this? XD

Could you provide screenshots of the relevant tables and the setup of the formula field please?

I made an example base:

https://airtable.com/shrwA5tpgORZyaULy

 

What I am trying to do is best suited for Google Sheets really, but all my data is in Airtable.  😲

I made an example base:

https://airtable.com/shrwA5tpgORZyaULy

 

What I am trying to do is best suited for Google Sheets really, but all my data is in Airtable.  😲


Thanks for the example base!  You'll need to link all your records in Table 1 to a single record in Totals, once you've done that it should work as expected

I just gives me all zeros instead of the actual total. 😕😕 Not sure what I am doing wrong.

I just gives me all zeros instead of the actual total. 😕😕 Not sure what I am doing wrong.


Could you make your changes to the example base so that I can help troubleshoot?

I gave up and just made a "grouped" view.

Reply


Terms & Conditions