Formula to Sum all Selections with a Number

Miles Allison

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 Multi-Select Dropdown

Sanjee Choudhuri

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 multi-select, which would makes it more difficult. Let me ruminate and get back to you