Formula to Sum all Selections with a Number


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
    edited 07/13/22

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!