Calculate new values from existing ones using expressions.
About expressions
There are several places in the app editor where you can use expressions to affect your app's behavior and provide users with advanced functionality. Several AppSheet features use expressions, including: app formulas, initial values, column constraints, virtual columns, and deep links.
AppSheet checks all expressions to ensure they are correctly formed and being used in an appropriate manner. For example, if an expression is being used to assign an initial value to a column of type Number
, AppSheet checks that the result of the expression is indeed a Number
.
Note: If you're familiar with spreadsheet formulas in Microsoft Excel or Google Sheets, you'll find AppSheet expressions similar in syntax and meaning.
An expression may be built with any combination of the following:
Constants
- Numbers: any whole numbers (integers) or real (floating-point) numbers, positive or negative.
- Dates and times, enclosed in double quotes. Format dates as
MM/DD/YYYY
and times asHH:MM:SS
. For example,"12/31/1999"
and"10:15:00"
. See also Date and time expressions. - Text, enclosed in double quotes. For example,
"Wordy words"
.
Columns
- Use the value of a column by enclosing the column's name in square brackets like this:
[Column]
. Then, you can use columns in expressions. - Dereferences are a type of expression that is useful when you have references between tables.
- To use columns from other tables in the app that aren't connected using references, specify the table name and column value using the following syntax:
Table[Column]
Build expressions
Learn more about building expressions with AppSheet.
Use Expression AssistantLearn how build expressions using Expression Assistant in the AppSheet editor. |
Expression typesUnderstand the types of expressions you can build. |
Column expressionsBuild column expressions that are dynamically computed to determine the behavior of a specific column when the user tries to enter or change its value. For example, you can use column constraints to control the behavior of the data in each column. |
List expressionsBuild list expressions that are dynamically computed to determine the contents of a list. |
AppSheet function listView all of the AppSheet functions that can be used when building expressions. |
Tips and tricksLearn tips and tricks for building expressions from the AppSheet Community: |
Sample template
Use the Quote Calculator template which shows the use of various expressions in app formula.