Formula (Extended): $ISTEXT Function
Overview¶
Return true if the argument is a string.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| String | Arbitrary String | Required |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| String | Yes*1 | Yes*2 | Yes*2 | Yes*1 | Yes*2 |
*1: Determined as follows based on input value
| Input value | Result |
|---|---|
| Blank | false |
| Half-width numerical value only | false |
| Full-width numerical value | true |
| Other strings | true |
*2: Always false
Return Value¶
True if string. Otherwise, false.
Return Value for Target Column¶
| Target | Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display the string "True" or "False" |
| Numerical Value (including work volume, progression rate, remaining work volume) | Do not display |
| Date (including start and completion) | Do not display |
| Description (including content) | Display the string "True" or "False" |
| Check (including lock) | Check ON if true, check OFF if false |
Usage Example ①¶
Specify parameters by screen column name (name displayed)


