How to create formula in a multi-select column that will populate added value when multiple selected

Options

Can someone help me? If I have a multi-selection column and want to have it calculate the total value if more than one is selected what would I need to change in this formula?

I need to provide values to the selections and if multiple selections are made I'd like to have it populate the total value. This column is group in to a final scoring column formula. I was trying to prevent having to add 4 more columns and then add those to the final score formula for 6 different sheets. Thanks!

=IF(LEFT([Business Critical]@row, 1) = "1", 50,

IF(LEFT([Business Critical]@row, 1) = "2", 25,

IF(LEFT([Business Critical]@row, 1) = "3", 30,

IF(LEFT([Business Critical]@row, 1) = "4", 25,

IF(LEFT([Business Critical]@row, 1) = "5", 50, 0)))))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!