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 do I convert Text (from a count) to a number?
Options
Comments

I've found this in Smartsheet Help \ Using Formulas where you may find the solution:
VALUE(): Converts a text value (that represents a number) to numeric formatCertain formulas will always return a value in text format, even if it looks like a number. For example: =LEFT(Cost5, 3)returns the value 425, which looks like a number but is actually stored in Smartsheet as text. Using text values in a calculation will return an error message about invalid data types. Use the VALUE formula to convert text to numeric format. Example: =LEFT(Cost5, 3) * 4
 Result: #INVALID DATA TYPE
 Example: =VALUE(LEFT(Cost5, 3)) * 4
 Result: 1700
This discussion has been closed.