Need to sum numbers in a dropdown multi select cell
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
Best Answer
-
OMG lol. Didn't even cross my mind wow. Thank you. Was way overthinking this. Yes this works
Answers
-
This may sound simplistic, but why not just make it a single-select and add 1.5 as an option?
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
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!
-
OMG lol. Didn't even cross my mind wow. Thank you. Was way overthinking this. Yes this works
-
😂 Sometimes the brain just wants to write that super-cool formula so badly!
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
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!
Help Article Resources
Categories
Check out the Formula Handbook template!
