Re: Add a field that has numbers with commas

1097 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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


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?

2 Replies 2
4 - Data Explorer
4 - Data Explorer

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.