Multiple values in one cell?

I’d like to add multiple values into one cell. Preferably so that these values add up to one summarized value to another cell. How to do this?

Example: A 17.5 meters long flag festoon is done of 4 snippets of 5 meters, 5 meters, 5 meters, 2.5 meters. These snippet values should be in one cell and add up to total length into another cell.

From where are these numbers coming? Are you typing them in manually? Are they pulled by an automation? Are you trying to parse a larger corpus of text? Can you share a screenshot of the exact field you already have?

The more details you can provide, the better the chances of getting help. But Airtable’s formula fields should have you covered in this instance. They’re more than powerful enough for such use cases, so try to read up on them and see if anything comes to mind. If nothing else, come up with a bad plan, then report back explaining how it failed - those types of help requests usually get resolved the quickest.

1 Like

Welcome to the Airtable community!

Are you coming from a spreadsheet background? Airtable is a database, not a spreadsheet, and thus it works differently. There are only a handful of field types that allow entering multiple values: linked record fields, multiple select fields, multiple collaborator fields, and attachment fields. There is no field that will let you store multiple numbers directly.

What you can do is use linked record fields to store multiple values. You could have one table of [Products] that would include a row for a festoon, and another table of [Snippets] that would include rows for snippets. In your example, you would have four snippet rows with 5, 5, 5, and 2.5 as the length for each row. All four of these snippets would be linked to the festoon, and then you would have a rollup field to sum the total length.

1 Like

These numbers are typed manually. Now they are in a text field as you can see in the image, on the left total length and on the right the snippets. I’d like them to add up to the full length column.