Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create a sum of multiple numeric values extracted from the same text tfield

Topic Labels: Formulas
Solved
Jump to Solution
190 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

first off, my skills are a bit basic, so I hope you have patience with me… I have a text field in which multiple numbers are being output by an automation and separated with a comma (it displays the file size of attachments.)

My goal is now to get the sum of all of these numbers in a formula field (I want to display the total filesize of all numbers combined).

I have tried using VALUE(Internal Notes) but in that case the numbers are just mashed together and not being calculated at all. So instead of “100200” I want this to display “300”.

Can anyone help me out on what to do? Or should this be resolved using scripts or something else? Any help would be much appreciated.

Bildschirmfoto 2022-09-24 um 00.17.46

1 Solution

Accepted Solutions

I would convert that field to a linked record field. Then you could create a Rollup field with the formula SUM(values) to get the total.

See Solution in Thread

2 Replies 2

I would convert that field to a linked record field. Then you could create a Rollup field with the formula SUM(values) to get the total.

That worked perfectly, thanks for the tip!