Formula (Extended): $ISNUMBER Function
Overview¶
Return true if the argument is a numerical value.
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*3 | Yes*1 | Yes*3 |
*1: Return the result as follows based on the input value
| Input value | Result |
|---|---|
| Blank | false |
| Half-width numerical value only | true |
| Full-width numerical value | false |
| Other strings | false |
*2: Always return true
*3: Always return false
Return Value¶
If it is a numeric value, true. 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)
Formula¶
Parameters¶
Calculation Result¶
