Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 18, 2023 10:47 AM
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
Apr 18, 2023 08:43 PM
Could you provide screenshots of the relevant tables and the setup of the formula field please?
Apr 20, 2023 12:58 PM - edited Apr 20, 2023 12:59 PM
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. 😲
Apr 21, 2023 02:09 AM
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
Apr 21, 2023 03:14 AM
I just gives me all zeros instead of the actual total. 😕 Not sure what I am doing wrong.
Apr 24, 2023 02:32 AM
Could you make your changes to the example base so that I can help troubleshoot?
Apr 24, 2023 06:43 AM
I gave up and just made a "grouped" view.