Other Expressions

New to expressions and formulas? Try Expressions: The Essentials.

You can also learn more about other types of expressions.

Expressions may be used in various AppSheet features--app formulas, column constraints (Valid_If, Show_If, Required_If). initial values, and virtual columns--to customize app behavior and provide advanced functionality.

The expressions described here cover a range of needs and don't fit into any of the other expression categories: Conditional Expressions, Date and Time Expressions, List Expressions and Aggregates, Math expressions, Text Expressions, and Yes/No Expressions.

Functions

Conditional

• IF() - Either/or conditional evaluation

• IFS() - First-match conditional evaluation

• SWITCH() - Choose-one conditional evaluation

Hyperlinks & URLs

• HYPERLINK() - New hyperlink

• LINKTEXT() - text component of hyperlink

• LINKURL() - URL component of hyperlink

Informational

• CONTEXT() - Information about the running app

• USEREMAIL() - User's email address

• USERLOCALE() - User's locale

• USERNAME() - User's name

• USERROLE() - Assigned role of approved user

• USERSETTINGS() - Specified user-setting value

LatLong & XY

• DISTANCE() - Distance between two locations

• GETX() - X component of XY value

• GETY()- Y component of XY value

• HERE() - Current location

• LAT() - Latitude component of LatLong value

• LATLONG() - LatLong from components

• LONG() - Longitude component of LatLong value

Utility

• TEXT_ICON() - Icon from text

• UNIQUEID() - Pseudo-unique ID