RIGHT Function

Returns the rightmost characters from a text string
Sample usage
RIGHT("Hello World", 3)
Syntax
RIGHT(
  • text
  • [
    num_chars
    ]
)
  • text
    The text containing the characters to return
  • num_chars
    —[optional]
    Starting from the rightmost character, the number of characters to return. If a number isn’t provided, only the first character from the right will be returned
Usage notes
  • With right-to-left languages (such as Arabic), RIGHT will return the leftmost characters instead.
Examples

This example references the following sheet information:

 Clothing ItemSold DateStatusOrder Date
1T-Shirt02/12/19 1:55 PMGreen02/12/19
2Pants02/15/19 10:23 AMRed02/15/19
3Jacket02/20/19 2:45 PMYellow02/20/19

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

FormulaDescriptionResult
=RIGHT([Clothing Item]1, 5)Returns the five rightmost characters in row 1 of the Clothing Item column Shirt
=COUNTIF([Sold Date]:[Sold Date], RIGHT(@cell, 2) = "PM")Counts the number of values in the Sold Date column that return the two rightmost characters at the cell level equal to PM. Rows 1 and 3 apply.2
=IF(Status2 = "Red", RIGHT([Order Date]2, 8))Returns the eight rightmost characters from row 2 of the Order Date column if row 2 of the Status column equals Red02/15/19

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