EXPRESSIONS

How to use expressions to change the behavior of your apps.

Santiago Uribe Montoya avatar Tony Fader avatar Praveen Seshadri (CEO AppSheet) avatar +3
117 articles in this collection
Written by Santiago Uribe Montoya, Tony Fader, Praveen Seshadri (CEO AppSheet) and 3 others

EXTRACT()

Extract values from text.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTDURATIONS()

Extract all durations from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTDATES()

Extract all dates from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTTIMES()

Extract all times from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTDATETIMES()

Extract all dates and times from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTPHONENUMBERS()

Extract phone numbers from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTMENTIONS()

Extract @mentions from text.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTHASHTAGS()

Extract #hashtags from text.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTEMAILS()

Extract email addresses from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTCHOICE()

Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTNUMBERS()

Extract numbers from text, whether they are written with digits or in word form.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

EXTRACTPRICES()

Extract prices from a text field.
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated this week

INTERSECT()

S
Written by Shawn Crabtree
Updated over a week ago

OCRTEXT()

Extract all text from an image
Tony Fader avatar
Written by Tony Fader
Updated this week

UNIQUE()

Documents the unique function for lists
S
Written by Shawn Crabtree
Updated over a week ago

Expressions: The Essentials

Learn how expressions can be used in AppSheet and get started with your own.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Expression Assistant and Expression Builder

Tools to help construct and test expressions.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago
Expression Types

Column Value Expressions

Write an expression to get a value from a specific column and row.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Conditional Expressions

How to use expressions so that behavior depends on a set of conditions.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Date and Time Expressions

Incorporate dates and times into the behavior of your app.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

List Expressions and Aggregates

List expressions use operators that result in a list or numeric value.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Math Expressions

Use mathematical expressions to make calculations.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Text Expressions

Use text values to create keys, get a user's name or email, and determine the value of other expressions.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Yes/No Expressions

Write expressions where the result is either TRUE or FALSE.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Other Expressions

Expressions to modify text, create unique IDs, and work with location.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Backward Compatibility Expressions

Learn about obsolete expressions and what we still support.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago
Functions

ABS()

Arithmetic absolute value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

AND()

Are all true?
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

ANY()

One arbitrary list item
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

AVERAGE()

Arithmetic average of list items
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

CEILING()

Nearest higher integer
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

CONCATENATE()

Merged text from parts
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

COUNT()

Number of list items
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

DATE()

Date from Date, DateTime, or Time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

DATETIME()

DateTime from Date, DateTime, or Time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

DAY()

Day of month from Date, DateTime, or Time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

EOMONTH()

Date of last day of a month from Date or DateTime
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

ENCODEURL()

Text encoded for use in URL
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

FILTER()

Select rows of table or slice
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

FIND()

Position of fragment in text
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

FLOOR()

Nearest lower integer
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

HERE()

Current location
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

HOUR()

Hour of day from Duration
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

HYPERLINK()

New hyperlink
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

IF()

Either/or conditional evaluation
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

IFS()

First-match conditional evaluation
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

INDEX()

One specific list item
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

INITIALS()

First character of each word
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

ISBLANK()

Is value absent?
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

ISNOTBLANK()

Is value present?
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LAT()

Latitude component of location
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LATLONG()

LatLong from components
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LEFT()

Left-most characters of text
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LEN()

Number of characters in textual value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKTEXT()

Text component of hyperlink
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKTOAPP()

Constructed deep link to app
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKTOFORM()

Constructed deep link to form
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKTOROW()

Constructed deep link to row
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKTOVIEW()

Constructed deep link to view
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LINKURL()

URL component of hyperlink
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LIST()

New list
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LN()

Natural logarithm of a numeric value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LOG()

Logarithm of a numeric value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LOG2()

Base 2 logarithm of a numeric value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LOG10()

Base 10 logarithm of a numeric value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LONG()

Longitude component of location
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LOOKUP()

Get column value from row in table or slice
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

LOWER()

Convert text to lowercase.
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MAX()

Highest item in list
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MAXROW()

Row with greatest value in column
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MID()

Characters from text
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MIN()

Lowest item in list
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MINROW()

Row with lowest value in column
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MINUTE()

Minute of hour from Duration
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MOD()

Arithmetic remainder from integer division
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

MONTH()

Month of year from Date, DateTime, or Time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

NOT()

Is it false?
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

NOW()

Current date & time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

OR()

Are any true?
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

ORDERBY()

Sort row references
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

POWER()

Arithmetic exponentiation
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

RANDBETWEEN()

Random integer from range
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

RIGHT()

Rightmost characters of text
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

ROUND()

Nearest integer
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SECOND()

Second of minute from Duration
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SELECT()

Gather column values from row in table or slice
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SORT()

Sorted list items
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SPLIT()

List from text
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SQRT()

Arithmetic square root
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

STDEVP()

Arithmetic standard deviation of list items
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SUBSTITUTE()

Text with replacements
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SUM()

Arithmetic sum of list items
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

SWITCH()

Chose-one conditional evaluation
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

TIME()

Time from Date, DateTime, or Time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

TIMENOW()

Current time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

TODAY()

Current date
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

TOP()

Initial list items
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

UNIQUEID()

Pseudo-unique ID
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

UPPER()

Convert text to uppercase.
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

USEREMAIL()

User's email address
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

USERLOCALE()

User's locale
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

USERNAME()

User's name
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

USERROLE()

Get assigned role of approved user
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

USERSETTINGS()

Specified user setting value
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

UTCNOW()

Current date & time in UTC
Tony Fader avatar
Written by Tony Fader
Updated over a week ago

WEEKDAY()

Day of week from Date or DateTime
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

WEEKNUM()

Week of year from Date or DateTime
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

WORKDAY()

Computed date excluding non-work days
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago

YEAR()

Year from Date, DateTime, or Time
Brian Sabino avatar
Written by Brian Sabino
Updated over a week ago