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
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
