Need to sum numbers in a dropdown multi select cell

Elguapo24

I have a multiselect cell that is used to select the time certain training education takes. I have .5 for 30 mins and 1 for an hour. Our educators can also select the 1 and .5 if the education takes an hour and a half. I would like to be able to sum these two if they selected both. I have searched this community and have found the countm and contains but can't seem to figure how to make them sum. Appreciate any insights. Thanks

Elguapo24

OMG lol. Didn't even cross my mind wow. Thank you. Was way overthinking this. Yes this works

Jeff Reisman

@Elguapo24

This may sound simplistic, but why not just make it a single-select and add 1.5 as an option?

Elguapo24

OMG lol. Didn't even cross my mind wow. Thank you. Was way overthinking this. Yes this works

Jeff Reisman

https://community.smartsheet.com/discussion/comment/321024#Comment_321024

😂 Sometimes the brain just wants to write that super-cool formula so badly!