Add a field that has numbers with commas

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.

image

Is there an easy way of doing this?

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

Welcome to the Airtable community!

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.

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.