Jun 11, 2023 05:47 AM
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
Jun 11, 2023 06:52 AM - edited Jun 11, 2023 06:53 AM
There is no easy nor straightforward way of doing that. You would need to switch that field to a linked record field.
Jun 11, 2023 11:33 AM
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.