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 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 Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.