VALUE Function

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.

Ask the Community