Help

Add a field that has numbers with commas

Topic Labels: Formulas
1187 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tony_Parr
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2
Tony_Parr
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.