Split a list of numbers in text format and sum them

Platform discussions
1

I have a list of numbers in a text format where the length is unknown and I want to split the numbers and sum them. For example, the expected result of 3,5,5,6 would be 19. In excel, this could be easily achieved using a combination of SPLITTEXT and SUM function.

How do I achieve the same using Formula in monday?

2

Can you use a number column with AI turned on to do it?

3

Hi @paprilia,

Try:

SUM(SPLIT({Text}, ","))

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.