Formula (Extended): $TEXT Function
Overview¶
Convert to a string with the display format applied.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Value | Arbitrary String | Required | |
| Display Format | Format specification strings available in C# | Required |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| Value | Yes | Yes | Yes | Yes | No |
| Display Format | Yes | No | No | Yes | No |
Return Value¶
A string with the display format is applied.
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 is a drop-down list with values, the options that match the return value are displayed. |
| Numerical Value (including work volume, progression rate, and 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 in date format. |
| Description (including content) | Display return value. |
| Check (including lock) | Do not display. |
Usage Example ①¶
Display numerical values with digit separators
By specifying the display format of category A, NumA is converted to digit separators and output as the calculation result to category B.
Calculation formula¶
Parameters¶
Calculation result¶
Usage Example ②¶
Display numerical values as currency (JPY)
By specifying the display format of ClassA, the calculation result will be output to ClassB in the currency symbol + NumA with digit separators. Specify "\" to escape "\".
Formula¶
Parameters¶
Calculation Result¶
Usage Example ③¶
Display date as year, month, and Sunday
By specifying the display format for ClassA, DateA will be converted to year, month, and Sunday and output as the calculation result in ClassB.
Formula¶
Parameters¶
Calculation Result¶
