Create a formula to total the individual values of a dropdown list from one column?
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

Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

Use the COUNTM function to count the number of selected elements in a multiselect cell.
=COUNTM([Multiselect column name]@row)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

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.

Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thank you Jeff! That was what I needed! Works perfect.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!