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 Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.