Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Totaling a dollar amount if a dropdown menu matches a criteria.

Topic Labels: Data Formulas
1426 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Anxious
7 - App Architect
7 - App Architect

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

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
6 Replies 6

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

Anxious
7 - App Architect
7 - App Architect

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.  😲

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)

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

Anxious
7 - App Architect
7 - App Architect

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

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)

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

Anxious
7 - App Architect
7 - App Architect

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

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)