Summing Number in Multi Select

[Harry_Batten]

Hello, if I have a cell with a range of numbers in, as selected via a multi select, is there a formula that can add these numbers up and give me the total, for example i'd like a column that will show the total of the numbers in image of the cell attached, which would be 14. 

Thanks

[ScottWorld]

There is no easy nor straightforward way of doing that. You would need to switch that field to a linked record field.

[kuovonne]

SUM(
  IF( FIND("2", {multiselect}, 2),
  IF( FIND("5", {multiselect}, 5),
  IF( FIND("7", {multiselect}, 7)
)

If there are other possible values for the multiselect, you will need to adjust the formula.

If there are two digit numbers as possible values, you will need to adjust the formula (and possibly the select choices) even more.