Converts a text value that represents a number into a number.
VALUE(LEFT(Cost5, 3)) * 4
text—The text value to convert.
- You can use VALUE within another function to ensure that 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