Add a field that has numbers with commas

[Tony_Parr]

Hello!

I have an automation that populates numbers separated by commas in the same entry.

Example:

12, 12, 12, 8

I want to create a field that will tell me the sum of these numbers, essentially replacing the commas with +. When I do this using the SUM function, it returns 0 likely because of the commas.

Is there an easy way of doing this?

[Tony_Parr]

These are text fields that are not being looked up or linked, so rollup isn’t an option unless there is a work around.

[kuovonne]

Welcome to the Airtable community!

Tony_Parr:

Is there an easy way of doing this?

No. There is no easy way of doing this in Airtable.
If you will always have four numbers, it could be done with a very complicated formula. If you will have an unpredictable number of numbers, your best bet is to use scripting.