Formula to Sum all Selections with a Number
Options
Hello,
I'm looking for a formula that can SUM all dropdown selections that contain a number. For example,
One Cell Contains: Advisor_1 Instructor_2 TA_1
Is there a formula that could sum all of these selections so that the returned value would be 4? The column is a MultiSelect Dropdown
Answers

If the number is always at the end of the string, you could use a substring function to isolate the number, set it as a integer in a hidden helper column, then sum that column!
Edit: Sorry I just saw it was a multiselect, which would makes it more difficult. Let me ruminate and get back to you
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!