Converts a text value that represents a number into a number
Sample Usage
VALUE(LEFT(Cost5, 3)) * 4
Syntax
VALUE(
-
text
- text—The text value to convert
Usage Notes
- You can use VALUE within another function to ensure a number will be returned from your formula. Certain formulas will always return a value in text format, even if it looks like a number. This will return an error when you attempt to perform mathematical calculations on the text, such as in the example below:
=RIGHT("H.264", 3) * 2
Result: #INVALID DATA TYPE
The =RIGHT("H.264", 3) portion of the formula returns 264, which looks like a number but is actually stored in Smartsheet as text. Use VALUE to convert text to numeric format so that the formula doesn’t produce an error:
=VALUE(RIGHT("H.264", 3)) * 2
Result: 528
Examples
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.