Formula to Sum all Selections with a Number
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!