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?
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.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.