Skip to content

Formula (Extended): $NOT Function

Overview

Return false if the argument is true.

Syntax

$NOT(Logical Expression)

Parameters

Parameter Type Required Description
Logical Expression Logical Expression Required

Column Usable as Parameters

Parameter Classification Numerical Value Date Description Check
Logical expression Yes*1 Yes*1 Yes*1 Yes*1 Yes

*1: Can be used as a variable to configure the "Logical Expression".
Example:
NumA == 1000
DateA > DateB
ClassA == "Text"

Return Value

If the argument is true, false. Otherwise, true.

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 $NOT function in usage example 1

Parameters

Parameters specified in usage example 1 of the $NOT function

Calculation Result

Calculation result of usage example 1 of the $NOT function

Usage Example ②

Specify logical expression as parameter

Formula

Formula using the $NOT function in usage example 2

Parameters

Parameters specified in usage example 2 of the $NOT function

Calculation Result

Calculation result of usage example 2 of the $NOT function