LEFT Function

Returns the leftmost characters from a text string
Sample Usage
LEFT("Hello World!", 3)
  • text
  • [
  • text
    The text that you want to return a portion from.
  • num_chars
    Starting from the leftmost character, the number of characters to return. If you didn't provide a number, the function returns only the first character.
Usage Notes
  • With right-to-left languages, LEFT will return the rightmost characters instead.

This example references the following sheet information:

  Item Number Transaction Total Units Sold Ship Date
1 C001 1,170.00 78 02/15/19
2 C002 1,491.00 42 03/20/19
3 C003 812.00 217 02/27/19

Given the table above, here are some examples of using LEFT in a sheet:

Formula Description Result
=LEFT("Smartsheet", 5) Returns the five leftmost characters from the text string Smartsheet  Smart
=LEFT([Item Number]2, 3) Return the three leftmost characters from a text string in row 2 of the Item Number column  C00
=SUMIF([Item Number]:[Item Number], LEFT(@cell, 3) = 
"C00", [Transaction Total]:[Transaction Total])
Sums the values in the Transaction Total column for rows where the value in the Item Number column returns the three leftmost characters equal to C00. Rows 1, 2, and 3 apply. 3,473.00


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