May 09, 2022 09:47 AM
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:
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:
May 09, 2022 07:44 PM
Hm, the quick and dirty way would be to create a formula field with the name of the item and the size, i.e.
{Item name} & ' ' & {Size}
And then convert that field to a “Link to” and create a new table. If this needs to be a long term thing, you could potentially use an automation to paste the formula field’s value into the link field
The only other way to deal with this would probably be with scripting I think