Formula (Extended): $RIGHT Function
Overview¶
Return the specified number of characters from the end of a string.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| String | Arbitrary String | Required | |
| [Number of characters] | Half-width numerical value. Integer of 0 or more | Optional | Specify the number of characters to be extracted. If omitted, it is assumed that 1 is specified. If 0 is specified, an empty string is returned. |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| String | Yes | Yes | Yes | Yes | No |
| [Number of characters] | Yes | Yes | No | Yes | No |
Return Value¶
The extracted string.
If [Number of characters] is greater than the number of characters in the string, the entire string is returned.
Return Value Display Content¶
| Target | Display Content of Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. If the return value is a half-width numerical value and a drop-down list with values, display the options that match the return value. |
| Numerical Value (including work volume, progression rate, remaining work volume) | Display return value only if the return value is a half-width numerical value. |
| Date (including start and completion) | Display return value only if the return value is a string in date format. |
| Description (including content) | Display return value. |
| Check (including lock) | Do not display. |
Usage Example ①¶
Specify the parameter by the screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
Usage Example ②¶
Specify the parameter [Number of characters]
Formula¶
Parameters¶
Calculation Result¶
