Sum a Multi Select Dropdown

Eva ✭✭✭✭
edited 06/22/22 in Formulas and Functions

I'm looking for the formula I would need to use if I have a multi select dropdown with numbers and words. I would only be looking to sum up the numbers. Some of the cells have numbers and words in the same cell.

Any help would be appreciated!




Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I wasn't able to make it work without using at least one helper column.

    If you want to leave the data entry in a single column and just pull the numbers into a separate column though, that formula would look like this:

    =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Hours@row, CHAR(10), ""), "Live In", ""), "Mutual", ""))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!