Extract numerical value from string

[MarvinW]

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.

[ScottWorld · Accepted solution]

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.

[MarvinW]

That worked perfectly, thanks for the tip!