Summing multiple values in a cell

[beejay23]

How do I sum multiple values in a cell. When I use the column Number, I could only insert one value into the form when I need to insert multiple values. When I do the text format, there is an apostrophe that blocks me from getting the sum. Reason why I am asking is because I am working on a project that gets the weight of multiple items in one cell separated by a comma, and I need to find the total weight from these separated values. 

[MultiTech]

Hey @beejay23 

Instead of manually entering a comma separated list into a text field, use an EnumList (base type number) field.

This way the actual data-type (the technical crap that makes things work) is what the system needs for the SUM() function to work.

Plus, the data entry method will be cleaner as well. 

Cheers!

[beejay23]

How would I use the SUM function with the EnumList? 

[MultiTech]

Literally just SUM([Enumlist])