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
