Returns the rightmost characters from a text string
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
Sample usage
RIGHT("Hello World", 3)
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 Item | Sold Date | Status | Order Date | |
|---|---|---|---|---|
| 1 | T-Shirt | 02/12/19 1:55 PM | Green | 02/12/19 |
| 2 | Pants | 02/15/19 10:23 AM | Red | 02/15/19 |
| 3 | Jacket | 02/20/19 2:45 PM | Yellow | 02/20/19 |
Given the table above, here are some examples of using RIGHT in a sheet:
| Formula | Description | Result |
|---|---|---|
| =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 Red | 02/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.