Yes/No Expression in Appy Pie App Sheet feature

By Abhinav Girdhar | Updated on April 7, 2022, 7:44 am

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.

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

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.