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

Summary of records, help needed

Topic Labels: Formulas
150 0
cancel
Showing results for 
Search instead for 
Did you mean: 

dear airtable community, i would like to create a formula that sums up the size of the identical item.

in the screenshot you will see, that every record has only one size, even though its sometimes the identical sneaker.

i want it to be:

-“dunk low disrupt 2 pale ivory black” : 39 EU - 8W US [case 1: only one record with the title - nothing should be changed, just display the available size]
-“dunk low light violet (venice)” : 38 EU - 7W US [case 2: multiple records with the same title, but with the identical size - only one record should include the size they all share and the others should be empty]
-“dunk low two tone grey” : 38 EU - 5.5Y US / 44 EU - 10 US [case 3: multiple records with the same title, but with different sizes - only one record should include all the sizes which are seperated with a " / " and the others should be empty.

if anyone of you could help me with this challenge i would highly appreciate it, i hope i described the requirements understandable, if not feel free to let me know.

thanks in advance and stay safe guys! :slightly_smiling_face:

Bildschirmfoto 2022-04-13 um 19.41.58

0 Replies 0