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 |
鉴于上面的表中,下面是一些例子sing RIGHT in a sheet:
| Formula | Description | Result |
|---|---|---|
| =RIGHT([Clothing Item]1, 5) | Returns the five rightmost characters in row 1 of theClothingItemcolumn | Shirt |
| =COUNTIF([Sold Date]:[Sold Date], RIGHT(@cell, 2) = "PM") | Counts the number of values in theSold Datecolumn that return the two rightmost characters at the cell level equal toPM.Rows 1 and 3 apply. | 2 |
| =IF(Status2 = "Red", RIGHT([Order Date]2, 8)) | Returns the eight rightmost characters from row 2 of theOrder Datecolumn if row 2 of theStatuscolumn equalsRed | 02/15/19 |
Still need help?
Use theFormula Handbook templateto 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.