Other expressions

Modify text, create unique IDs, and work with location

Expressions may be used in various AppSheet features - app formulas, column constraints (Valid_If, Show_If, Required_If) - 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 types.

New to expressions and formulas? See also Expressions: The Essentials.



  • IF() - Either/or conditional evaluation
  • IFS() - First-match conditional evaluation
  • SWITCH() - Choose-one conditional evaluation


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


Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center