Yes/no Expression In Appy Pie App Sheet Feature

Yes / No Expression :

TRUE/FALSE
 
A result that is either TRUE (Yes) or FALSE (No) is produced by TRUE/FALSE function.
 
Syntax
 
YESNO('TRUE')
 
Example                   
 
YESNO(‘FALSE’): FALSE
 
YESNO(‘TRUE’): TRUE

YESNO(2) : FALSE

EQUAL
 
The EQUAL  function returns TRUE if two specified numbers are equal and returns FALSE if the numbers are not equal.

Syntax

EQUAL([value_1],[value_2])  
 
Example
 
EQUAL([2], [2]) = TRUE
 
EQUAL([2], [3]) = FALSE
 
Learn more about EQUAL

NOTEQUAL

The NOTEQUAL  function returns TRUE if two specified numbers are not equal and returns FALSE if two numbers are equal.

Syntax

NOTEQUAL([value_1],[value_2])  

Example

NOTEQUAL([2], [2]) = FALSE
NOTEQUAL([2], [3]) = TRUE

Learn more about NOTEQUAL

GREATERTHAN

The GREATERTHAN function returns TRUE if the first number is greater than the second, and FALSE otherwise.

Syntax

GREATERTHAN([value_1],[value_2])
 
Example
 
GREATERTHAN([4], [2]) = TRUE

Learn more about GREATERTHAN

LESSTHAN
 
The LESSTHAN function returns TRUE if the first number is less than the second, and FALSE otherwise.

Syntax
 
LESSTHAN([value_1],[value_2])
 
Example
 
LESSTHAN([4], [2]) = FALSE
 
Learn more about LESSTHAN

GREATERTHANEQUAL

The GREATERTHANEQUAL function returns TRUE if the first number is greater than or equal to the second number, and FALSE otherwise.

Syntax

GREATERTHANEQUAL([value_1],[value_2])

Example

GREATERTHANEQUAL([4], [2]) = TRUE
GREATERTHANEQUAL([4], [4]) = TRUE

Learn more about GREATERTHANEQUAL

LESSTHANEQUAL

The LESSTHANEQUAL function returns TRUE if the first number is less than or equal to the second number, and FALSE otherwise.

Syntax

LESSTHANEQUAL([value_1],[value_2])

Example

LESSTHANEQUAL([1], [2]) = TRUE

Learn more about LESSTHANEQUAL

NOT

If the specified condition is true, the NOT function returns FALSE and if the specified condition is false, the NOT function returns TRUE.

Syntax
 
NOT({cond_1})

Example
 
NOT(EQUAL(8,8)) = FALSE
 
NOT(TRUE) : FALSE
 
NOT(FALSE) : TRUE
 
NOT(ISBLANK([Summary])) : TRUE if the Summary column value is not blank.
 
NOT(WEEKDAY(TODAY()) = "Friday") : TRUE if today's weekday name is not Friday.
 
NOT(IN([Month]), {"March", "May"}) : TRUE if the Month column value is not March or May.

Arguments
 
A (YES/NO) Condition that results in TRUE or FALSE.
 
Return Value
 
Yes/No: The inverse of condition that is if the condition is TRUE, the function will return FALSE and if the condition is FALSE, it will return TRUE.
 
Learn more about NOT

ISBLANK

If the value or referenced cell is blank, the ISBLANK function returns TRUE, and if the value or referenced cell is not blank, it returns FALSE.

Syntax
 
ISBLANK([column])
 
Example
 
ISBLANK([ ]) = TRUE
 
ISBLANK("") : TRUE
 
NOT(ISBLANK("")) : FALSE
 
ISBLANK(0) : FALSE
 
ISBLANK(LIST()) : TRUE.
 
ISBLANK(LIST("Red", "Yellow", "Black")) : TRUE if List has no value, FALSE otherwise.
ISBLANK([Location]) : TRUE if the Address column has no value, FALSE otherwise.
 
Arguments

• Any singular value of any type
•  List of any type.

 Return Value

Yes/No: The function returns TRUE if this has no value, and FALSE otherwise. A list that is empty has no value.
 
Learn more about ISBLANK

ISNOTBLANK

If the value or referenced cell is not blank, the ISNOTBLANK function returns TRUE, and if the value or referenced cell is blank, it returns FALSE.  

Syntax

ISNOTBLANK([column])

Example

ISNOTBLANK([4]) : TRUE
 
ISNOTBLANK("") : FALSE
 
NOT(ISNOTBLANK("")) : TRUE
 
ISNOTBLANK("Hello!") : TRUE
 
ISNOTBLANK(0) : TRUE
 
ISNOTBLANK(LIST()) : FALSE.
 
ISNOTBLANK(LIST("Red", "Yellow", "Black")) : TRUE if List has a value, FALSE Otherwise
 
ISNOTBLANK([Location]) : TRUE if the Address column has a value, FALSE if the column has no value.

Arguments

• Any singular value of any type
• List of any type.

 Return Value

Yes/No: This function returns TRUE if this has a value, and FALSE otherwise. A list that is empty has no value.

IN

This function returns TRUE if the search target matches a minimum of one item in the search list, and FALSE otherwise.

Syntax
 
IN([Summary], LIST([value1], [value2]))
 
Examples
 
IN("a", {"a", "b", "c"}) : TRUE
 
IN("bc", {"a", "b", "c"}) : FALSE
 
IN("d", {"a", "b", "c"}) : FALSE
 
IN("Red", {"I'm bored!"}) : FALSE
 
IN(".com", LIST([Email])): It is the value of the Email column exactly .com and nothing else.
 
Arguments

• Summary: This denotes the value to be determined and this value's type must be compatible with that of the items of the search list.
• List (EnumList or List of any type): A list of items where the search is to be carried out while ensuring that the type of items is compatible with that of the search target.

 Return Value

Yes/No : The function returns TRUE if the search target matches a minimum of one item in the search list and FALSE otherwise.  
Note:The match is case-insensitive, that is the upper- and lower-case letters are equivalent.

CONTAINS
 
This function returns TRUE if the fragment is found in the search value and False otherwise.
 
Syntax

CONTAINS(Fragment,Value)   

Examples

CONTAINS("abc", "a") : TRUE
 
CONTAINS("abc", "bc") : TRUE
 
CONTAINS("abc", "d") : FALSE
 
CONTAINS("I love my country!", "try")  : TRUE
 
CONTAINS([Location], "PO Box"): Does the Location indicate a post office box?
 
CONTAINS([Email], "@"): Does the Email contain at least one at sign (@)?

Return Value

Yes/No : This function returns TRUE if the fragment is found in the search value and False otherwise.
Note:The match is case-insensitive, that is the upper- and lower-case letters are equivalent.

AND
 
If all of the provided conditions are logically true, the AND function returns TRUE, and if any of the provided conditions are logically false, this function returns FALSE.
 
Syntax
 
AND([cond_1], [cond_2])
 
Example

AND(ISBLANK([Base]), ISBLANK([Num]))
 
AND(FALSE, FALSE) : FALSE
 
AND(TRUE, TRUE) : TRUE

AND(FALSE, TRUE) : FALSE
 
AND(TRUE, FALSE) : FALSE
 
AND(ISNOTBLANK([Section]), (EQUAL([Section] , "A")) : TRUE only if the Section column value is both present and has a value A; otherwise FALSE. See also: ISNOTBLANK().
 
AND(([Name] = "App"), (GREATERTHAN([RATING],3), [Preferred?]) : TRUE only if the row is for the company named App that has a review of 5 or higher and is a preferred; FALSE otherwise.
 
Arguments
 
A (Yes/No) condition that results in TRUE or FALSE. A minimum of two conditions are required.
 
Return Value
 
Yes/No: This function returns TRUE if every condition is TRUE, otherwise FALSE.
 
Learn more about AND
 

OR

If any of the conditions is logically true, the OR function returns TRUE, and if all the conditions are logically false, this function returns FALSE.

Syntax

OR([cond_1], [cond_2])

Example

OR(ISBLANK([Base]),ISBLANK([Num])): TRUE, If any of the conditions is logically true False otherwise
 
OR(FALSE, FALSE) : FALSE

OR(TRUE, TRUE) : TRUE

OR(FALSE, TRUE) : TRUE

OR(TRUE, FALSE) : TRUE

OR(EQUAL(Red, [Color]), EQUAL(Yellow, [Color]), EQUAL(Green, [Color])) : TRUE if the Color column value is any of Red, Yellow, or Green.

Arguments

A (Yes/No) condition that results in TRUE or FALSE. A minimum of two conditions are required.

Return Value

Yes/No: This function returns TRUE if any of the provided condition is TRUE, otherwise FALSE.