Converts a text value that represents a number into a number
Syntax
VALUE(text)
- text—The text value to convert
Sample usage
VALUE(LEFT(Cost5, 3)) * 4
Usage notes
- You can use VALUE within another function to ensure that your formula returns a number. Certain formulas always return a value in text format, even if it looks like a number. This returns an error when you attempt to perform mathematical calculations on the text, such as in the following example:
=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 it's actually stored in Smartsheet as text. Use VALUE to convert text to a 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, view 100+ formulas, 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.