User Manual

10.03.2024

MANUAL

Formula (Extended): $ISNUMBER Function

## Overview Return true if the argument is a numerical value. ## Syntax ``` $ISNUMBER(String) ``` ## 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 ![image](https://pleasanter.org/binaries/c2a7ef6e6dbf4b59a2319575393cc537) ### Parameters ![image](https://pleasanter.org/binaries/ea9fde654b524fbe9687b5896fe83806) ### Calculation Result ![image](https://pleasanter.org/binaries/a642fa97e273451d9a4b60c8eabedd1f)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.