Expressions

Expressions: The Essentials

Learn how expressions can be used in AppSheet and get started with your own.

Written by Santiago Uribe Montoya
Updated over a week ago

Expression Assistant

Tool to help construct and test expressions.

S

Written by Steve Coile
Updated over a week ago

Column Value Expressions

Write an expression to get a value from a specific column and row.

S

Written by Steve Coile
Updated over a week ago

Conditional Expressions

How to use expressions so that behavior depends on a set of conditions.

Written by Santiago Uribe Montoya
Updated over a week ago

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

S

Written by Steve Coile
Updated over a week ago

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

S

Written by Steve Coile
Updated over a week ago

Math Expressions

Calculate numeric values from other numeric values.

S

Written by Steve Coile
Updated over a week ago

List Expressions

List expressions use and/or produce lists of values.

S

Written by Steve Coile
Updated yesterday

Text Expressions

Text expressions use and/or produce textual values.

S

Written by Steve Coile
Updated over a week ago

Yes/No Expressions

Write expressions where the result is either TRUE or FALSE.

Written by Santiago Uribe Montoya
Updated over a week ago

Other Expressions

Expressions to modify text, create unique IDs, and work with location.

S

Written by Steve Coile
Updated over a week ago

Backward Compatibility Expressions

Learn about obsolete expressions and what we still support.

S

Written by Steve Coile
Updated over a week ago

Column Constraints

Control inputs using column constraints.

Written by Santiago Uribe Montoya
Updated over a week ago

Valid_If Column Constraint

How to check if a given form input is valid based on its type.

Written by Santiago Uribe Montoya
Updated over a week ago

Required_If Column Constraint

Conditionally require a column value.

S

Written by Steve Coile
Updated over a week ago

Suggested Values for a Column

How to suggest a dynamic list of values for a column

Written by Praveen Seshadri (CEO AppSheet)
Updated over a week ago

Show_If Column Constraint

Conditionally show or hide a column value.

Written by Santiago Uribe Montoya
Updated over a week ago

Editable_If Column Constraint

Conditionally allow the user to edit a column value.

S

Written by Steve Coile
Updated over a week ago

List Addition

Add lists together to produce another containing all items in the originals.

S

Written by Steve Coile
Updated yesterday

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

S

Written by Steve Coile
Updated yesterday

List from Expressions

Create a list from the results of expressions.

S

Written by Steve Coile
Updated yesterday

List from Table-Column Reference

Create a list from the values in a column of a table.

S

Written by Steve Coile
Updated yesterday

List from Values

Create a list from raw values.

S

Written by Steve Coile
Updated this week

List Functions

Create lists using functions.

S

Written by Steve Coile
Updated this week

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren't also in the second..

S

Written by Steve Coile
Updated this week

ABS()

Arithmetic absolute value

S

Written by Steve Coile
Updated over a week ago

AND()

Are all true?

S

Written by Steve Coile
Updated over a week ago

ANY()

One arbitrary list item

S

Written by Steve Coile
Updated over a week ago

APP()

S

Written by Steve Coile
Updated over a week ago

AVERAGE()

Arithmetic average of list items

S

Written by Steve Coile
Updated over a week ago

CEILING()

Nearest higher integer

S

Written by Steve Coile
Updated over a week ago

CONCATENATE()

Merged text from parts

S

Written by Steve Coile
Updated over a week ago

CONTAINS()

Does text contain fragment?

S

Written by Steve Coile
Updated over a week ago

CONTEXT()

Information about the running app.

S

Written by Steve Coile
Updated over a week ago

COUNT()

Number of list items

S

Written by Steve Coile
Updated over a week ago

DATE()

Date from Date, DateTime, or Time

S

Written by Steve Coile
Updated over a week ago

DATETIME()

DateTime from Date, DateTime, or Time

S

Written by Steve Coile
Updated over a week ago

DAY()

Day of month from Date, DateTime, or Time

S

Written by Steve Coile
Updated over a week ago

DECIMAL()

Decimal from any value

S

Written by Steve Coile
Updated over a week ago

DISTANCE()

Distance between locations

S

Written by Steve Coile
Updated over a week ago

EOMONTH()

Date of last day of a month from Date or DateTime

S

Written by Steve Coile
Updated over a week ago

EOWEEK()

Date of last day of a week from Date or DateTime

S

Written by Steve Coile
Updated over a week ago

EWOMONTH()

Date of last weekday of a month from Date or DateTime

S

Written by Steve Coile
Updated over a week ago

ENCODEURL()

Text encoded for use in URL

S

Written by Steve Coile
Updated over a week ago

EXTRACT()

Extract values from text.

S

Written by Steve Coile
Updated over a week ago

EXTRACTCHOICE()

Extract one Yes/No value within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTDATES()

Extract list of dates within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTDATETIMES()

Extract list of DateTime values within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTDOMAINS()

S

Written by Steve Coile
Updated over a week ago

EXTRACTDURATIONS()

Extract list of Duration values within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTEMAILS()

Extract list of Email values within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTHASHTAGS()

Extract list of hashtags within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTMENTIONS()

Extract list of mentions within textual value

S

Written by Steve Coile
Updated over a week ago

EXTRACTNUMBERS()

Extract list of numeric values within text value

Written by Jennifer Cadence
Updated over a week ago

EXTRACTPHONENUMBERS()

Extract list of phone numbers within text value

Written by Jennifer Cadence
Updated over a week ago

EXTRACTPRICES()

Extract list of Price values within text value

Written by Jennifer Cadence
Updated over a week ago

EXTRACTTIMES()

Extract list of Time values within text value

Written by Jennifer Cadence
Updated over a week ago

FILTER()

Select rows of table or slice

S

Written by Steve Coile
Updated over a week ago

FIND()

Position of fragment in text

S

Written by Steve Coile
Updated over a week ago

FLOOR()

Nearest lower integer

S

Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_AT()

S

Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_FROM()

S

Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_WITH()

S

Written by Steve Coile
Updated over a week ago

GETX()

S

Written by Steve Coile
Updated over a week ago

GETY()

S

Written by Steve Coile
Updated over a week ago

HERE()

Current location

S

Written by Steve Coile
Updated over a week ago

HYPERLINK()

New hyperlink

S

Written by Steve Coile
Updated over a week ago

HOUR()

Hour of day from Duration

S

Written by Steve Coile
Updated over a week ago

IF()

Either/or conditional evaluation

S

Written by Steve Coile
Updated over a week ago

IFS()

First-match conditional evaluation

S

Written by Steve Coile
Updated over a week ago

IN()

Is item in list?

S

Written by Steve Coile
Updated over a week ago

INDEX()

One specific list item

S

Written by Steve Coile
Updated over a week ago

INITIALS()

First character of each word

S

Written by Steve Coile
Updated over a week ago

ISBLANK()

Is value absent?

S

Written by Steve Coile
Updated over a week ago

ISNOTBLANK()

Is value present?

S

Written by Steve Coile
Updated over a week ago

INTERSECT()

Items common to two lists

S

Written by Steve Coile
Updated over a week ago

LATLONG()

LatLong from components

S

Written by Steve Coile
Updated over a week ago

LAT()

Latitude component of location

S

Written by Steve Coile
Updated over a week ago

LEFT()

Left-most characters of text

S

Written by Steve Coile
Updated over a week ago

LINKTEXT()

Text component of hyperlink

S

Written by Steve Coile
Updated over a week ago

LINKTOAPP()

Constructed deep link to app

S

Written by Steve Coile
Updated over a week ago

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view

S

Written by Steve Coile
Updated over a week ago

LINKTOFORM()

Constructed deep link to form

S

Written by Steve Coile
Updated over a week ago

LINKTOROW()

Constructed deep link to row

S

Written by Steve Coile
Updated over a week ago

LINKTOVIEW()

Constructed deep link to view

S

Written by Steve Coile
Updated over a week ago

LINKURL()

URL component of hyperlink

S

Written by Steve Coile
Updated over a week ago

LEN()

Number of characters in textual value

S

Written by Steve Coile
Updated over a week ago

LIST()

New list

S

Written by Steve Coile
Updated over a week ago

LN()

Natural logarithm of a numeric value

S

Written by Steve Coile
Updated over a week ago

LOG()

Logarithm of a numeric value

S

Written by Steve Coile
Updated over a week ago

LOG2()

Base 2 logarithm of a numeric value

S

Written by Steve Coile
Updated over a week ago

LOG10()

Base 10 logarithm of a numeric value

S

Written by Steve Coile
Updated over a week ago

LONG()

Longitude component of location

S

Written by Steve Coile
Updated over a week ago

LOOKUP()

Get column value from row in table or slice

S

Written by Steve Coile
Updated over a week ago

LOWER()

Convert text to lowercase.

S

Written by Steve Coile
Updated over a week ago

MAX()

Highest item in list

S

Written by Steve Coile
Updated over a week ago

MAXROW()

Row with greatest value in column

S

Written by Steve Coile
Updated over a week ago

MID()

Characters from text

S

Written by Steve Coile
Updated over a week ago

MIN()

Lowest item in list

S

Written by Steve Coile
Updated over a week ago

MINROW()

Row with lowest value in column

S

Written by Steve Coile
Updated over a week ago

MINUTE()

Minute of hour from Duration

S

Written by Steve Coile
Updated over a week ago

MOD()

Arithmetic remainder from integer division

S

Written by Steve Coile
Updated over a week ago

MONTH()

Month of year from Date, DateTime, or Time

S

Written by Steve Coile
Updated over a week ago

NOT()

Is it false?

S

Written by Steve Coile
Updated over a week ago

NOW()

Current date & time

S

Written by Steve Coile
Updated over a week ago

NUMBER()

Number from any value

S

Written by Steve Coile
Updated over a week ago

OCRTEXT()

Extract all text from an image

Written by Tony Fader
Updated over a week ago

OR()

Are any true?

S

Written by Steve Coile
Updated over a week ago

ORDERBY()

Sort row references

S

Written by Steve Coile
Updated over a week ago

POWER()

Arithmetic exponentiation

S

Written by Steve Coile
Updated over a week ago

RANDBETWEEN()

Random integer from range

S

Written by Steve Coile
Updated over a week ago

REF_ROWS()

Gather related rows from table or slice

S

Written by Steve Coile
Updated over a week ago

RIGHT()

Rightmost characters of text

S

Written by Steve Coile
Updated over a week ago

ROUND()

Nearest integer

S

Written by Steve Coile
Updated over a week ago

SECOND()

Second of minute from Duration

S

Written by Steve Coile
Updated over a week ago

SELECT()

Gather column values from row in table or slice

S

Written by Steve Coile
Updated over a week ago

SNAPSHOT()

Screenshot a view and embed in documents.

J

Written by Joshua Aldrich
Updated over a week ago

SORT()

Sorted list items

S

Written by Steve Coile
Updated over a week ago

SPLIT()

List from text

S

Written by Steve Coile
Updated over a week ago

SQRT()

Arithmetic square root

S

Written by Steve Coile
Updated over a week ago

STDEVP()

Arithmetic standard deviation of list items

S

Written by Steve Coile
Updated over a week ago

SUBSTITUTE()

Text with replacements

S

Written by Steve Coile
Updated over a week ago

SUM()

Arithmetic sum of list items

S

Written by Steve Coile
Updated over a week ago

SWITCH()

Chose-one conditional evaluation

S

Written by Steve Coile
Updated over a week ago

TEXT()

Format as text

S

Written by Steve Coile
Updated over a week ago

TEXT_ICON()

Icon from text

S

Written by Steve Coile
Updated over a week ago

TIME()

Time from Date, DateTime, or Time

S

Written by Steve Coile
Updated over a week ago

TIMENOW()

Current time

S

Written by Steve Coile
Updated over a week ago

TODAY()

Current date

S

Written by Steve Coile
Updated over a week ago

TOTALHOURS()

Count of hours in Duration

S

Written by Steve Coile
Updated over a week ago

TOP()

Initial list items

S

Written by Steve Coile
Updated over a week ago

TOTALMINUTES()

Count of minutes in Duration

S

Written by Steve Coile
Updated over a week ago

TOTALSECONDS()

Count of seconds in Duration

S

Written by Steve Coile
Updated over a week ago

TRIM()

Text with extraneous spaces removed

S

Written by Steve Coile
Updated over a week ago

UNIQUE()

Unique items in list

S

Written by Steve Coile
Updated over a week ago

UNIQUEID()

Pseudo-unique ID

S

Written by Steve Coile
Updated over a week ago

UPPER()

Convert text to uppercase.

S

Written by Steve Coile
Updated over a week ago

USERNAME()

User's name

S

Written by Steve Coile
Updated over a week ago

USEREMAIL()

User's email address

S

Written by Steve Coile
Updated over a week ago

USERLOCALE()

User's locale

S

Written by Steve Coile
Updated over a week ago

USERROLE()

Get assigned role of approved user

S

Written by Steve Coile
Updated over a week ago

UTCNOW()

Current date & time in UTC

S

Written by Steve Coile
Updated over a week ago

USERSETTINGS()

Specified user setting value

S

Written by Steve Coile
Updated over a week ago

WEEKDAY()

Day of week from Date or DateTime

S

Written by Steve Coile
Updated over a week ago

WEEKNUM()

Week of year from Date or DateTime

S

Written by Steve Coile
Updated over a week ago

WORKDAY()

Computed date excluding non-work days

S

Written by Steve Coile
Updated over a week ago

XY()

S

Written by Steve Coile
Updated over a week ago

YEAR()

Year from Date, DateTime, or Time

S

Written by Steve Coile
Updated over a week ago