New to expressions and formulas? Try Expressions: The Essentials.
You can also learn more about other types of expressions.
When using expressions, some values depend on other values conditionally. Here are some examples of conditional statements:
- If you oversleep, then you're late to work.
- If you drink a lot of water, then you're hydrated, but if you don't, you're dehydrated.
In expressions, you can approach these conditional situations in a few ways:
- IFS(<condition1>,<then-expression1>, <condition2>, <then-expression2>, ...) to provide a sequence of condition-value pairs that are evaluated left-to-right until one of the conditions is true.
- SWITCH(<expression>, <value1>, <result1>, <value2>, <result2>, ..., <default_result>) to choose one of the results based on the value of the expression. It's a variation of IFS.
- SWITCH(MONTH(TODAY()), 1, "January", 2, "February", 3, "March", 4, "April", 5, "May", 6, "June", 7, "July", 8, "August", 9, "September", 10, "October", 11, "November", "December"): converts the current month number into the current month name.
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 your users with advanced functionality.