Skip to content

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

Formula using the $ISTEXT function in usage example 1

Parameters

Parameters specified in usage example 1 of the $ISTEXT function

Calculation Result

Calculation result of usage example 1 of the $ISTEXT function