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

CRUSJ · 09/20/22

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.

Jeff Reisman · 09/20/22

@CRUSJ

Just multiply by .5, like so:

=COUNTM([Multi-select column name]@row) * .5

Jeff Reisman · 09/20/22

@CRUSJ

Use the COUNTM function to count the number of selected elements in a multi-select cell.

=COUNTM([Multi-select column name]@row)

CRUSJ · 09/20/22

https://community.smartsheet.com/discussion/comment/344126#Comment_344126

Hi Jeff, Thanks for answering. Wouldn't that only count the number of items checked though? I need the formula to total the value given to each of these dropdown items. They are each valued at 0.5.

Jeff Reisman · 09/20/22

@CRUSJ

Just multiply by .5, like so:

=COUNTM([Multi-select column name]@row) * .5

CRUSJ · 09/20/22

https://community.smartsheet.com/discussion/comment/344151#Comment_344151

Thank you Jeff! That was what I needed! Works perfect.

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

Best Answer

Answers

Help Article Resources

Categories