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:

  1. If you oversleep, then you're late to work.
  2. 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:

  • IF(<condition>,<then-expression>,<else-expression>)
  • 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

  • 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 in this article align with the Other Expressions section of the Expression Builder in the Editor. 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.

Did this answer your question?