Store list of numbers in LongText field, add them together and display the result in another Number

AppSheet AppSheet Q&A
, ,
1

I want to enter a list of numbers in a LongText field, one number in each row, and in another Number field show the sum of the entered numbers. I tried to use the expression in the Number field SUM(EXTRACTNUMBER([ListNumbers])), but it only extracted the first number in the row and not the rest and not the sum. Is there any expression that I can apply for this case or what I could do to solve it?

2

What is the reason for using a LongText and entering the numbers by rows?

Can you separate the numbers with commas? Then you can use this SUM(EXTRACTNUMBERS([ListNumbers]))

Using an EnumList type column with Number as base type give you a different entry method and will automatically store the numbers in a List. The the sun expression would be SUM([ListNumbers])

2 Likes