New to expressions and formulas? Try Expressions: The Essentials

You can also learn more about other types of expressions.

Before we start with a detailed explanation, here are three examples of yes/no statements:

  • Is today Wednesday?
  • Does the customer have more than $100 in the shopping cart?
  • Is 5 greater than 2?

Yes/No expressions produce a result that's either TRUE (Yes) or FALSE (No). These expressions are generally used in AppSheet where you need an IF statement. For example, when you see a Show_IF or Condition

Here's a Show_IF Condition:

Here's a general IF condition:

Yes/No Conditions

Yes/No Expressions use comparison operators that return a True or False result displayed as a Yes or No in AppSheet. These Yes/No expressions are composed of:

  • Comparison Operators
  • Composition Operators, and
  • Other Operators.

Comparison Operators

AppSheet supports Comparison Conditions by using comparison operators with two expression parameters that have comparable types. These rely on comparing two or more parameters. The expression will either have a true or a false result, depending on whether the comparison is valid.

For example, 5 > 2 is valid, but 5 > "Hello" is not valid.

  • Equals: =
  • Not Equals: <>
  • Greater Than: >
  • Greater Than or Equals: >=
  • Less Than: <
  • Less Than or Equals: <=

Learn more about Equals (EQ), Not Equals (NE), Greater Than (GT), Greater Than or Equals (GTE), Less Than (LT), and Less Than or Equals (LTE).

Composition Operators

This is a powerful way to combine multiple conditions. If you wrap multiple conditions with AND, OR, NOT, you can compare a greater number of things. These rely on the conditions of multiple components and can be used to determine what to do when something is true or false.

AND({condition 1},{condition 2},{condition 3},..,{condition n})

If all the conditions in the AND expression are true, then the result of the expression will be TRUE (Yes), if any of the conditions are not true, the result will be FALSE (No). Separate each condition with a comma. Each condition is an expression in itself, so be aware of how the expressions are nested.

Learn more about AND.

OR({condition 1},{condition 2},{condition 3},..,{condition n}) (OR)

If any of the conditions in the expression is TRUE then the OR expression will result in TRUE, otherwise it will be FALSE. Each condition is separated by a comma.

Learn more about OR.

NOT({condition})  (NOT)

If the condition result is TRUE, then wrapping it in NOT() results in FALSE. If the condition is FALSE, then wrapping it in NOT() results in TRUE.

Learn more about NOT.

Other Operators

AppSheet supports the following additional operators:

  • ISBLANK({*}) returns true if an expression is empty
  • CONTAINS({text_1},{text_2}): returns true if text_1 contains text_2
  • IN({*},{List}): returns true if a value is in a list

Learn more about ISBLANK.

Common and Complex Expressions

These are some examples of commonly used Yes/No expressions in AppSheet.

Common Expressions

If you wanted to do something when the value of column Color is green and it was completed today, here's the expression you would use:

  • AND([Color]="Green",[CompleteDate]>TODAY())

If you wanted to see whether there are any oranges recorded in the column Fruit, you would use this expression:

  • CONTAINS([Fruit],"Oranges")

Complex Expressions

These are some examples of more complex operations where more parameters are included.

  • OR(([Price]*[Quantity])>$10,000.00,[Price]>$100.00)
  • OR(CONTAINS([Fruit],"Oranges"),CONTAINS([Fruit],"Apples"),CONTAINS([Fruit],"Bananas"))

Learn More About Expressions

You can use column names, constants (like dates, names, or other values), and other mathematical operations to build your expression. The only condition is that the result is either TRUE or FALSE (Yes/No).

Expressions may be used in various AppSheet features--Initial Values, App Formulas, Virtual Columns and Column Constraints (Valid_If, Show_If, Required_If)--to customize app behavior and provide advanced functionality.

Expressions in this article align with the Yes/No Expressions section of the Expression Builder in the Editor.

Did this answer your question?