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
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
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!