VALUE Function

Converts a text value that represents a number into a number
Sample Usage
VALUE(LEFT(Cost5, 3)) * 4
  • text
  • text
    The text value to convert
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 

    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

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.

Ask the Community