Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to Sum Cells with Numbers & Text
Have a super basic question I just can't seem to find a quick answer for.
Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell with the following formula:
=15 + " min"
Result: 15 min
When I add 2 cells with that formula [=15 + " min"] + [=15 + " min"], the result is 0. How do I tell smartsheet to ignore the text string and focus on summing the numeric value only?