Create a formula to total the individual values of a dropdown list from one column?

edited 09/20/22 in Formulas and Functions

So I have a dropdown column that has 12 options and it does allow multiple selections. Each of these items is worth 0.5 value. I am trying to create a formula for another column to report the total value selected in this column by the end user. So if the user selects 3 of these items from the dropdown, I need the formula to total those into a value of 1.5.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!