User Manual

10.03.2024

MANUAL

Formula (Extended): $ISTEXT Function

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