EXPRESSIONS

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

Santiago Uribe Montoya avatar Tony Fader avatar Praveen Seshadri (CEO AppSheet) avatar +1
102 articles in this collection
Written by Santiago Uribe Montoya, Tony Fader, Praveen Seshadri (CEO AppSheet) and 1 other
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 this week

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
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

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

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

EOMONTH()

Date of last day 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

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

HERE()

Current location
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

HYPERLINK()

New hyperlink
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

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

LAT()

Latitude component of location
S
Written by Steve Coile
Updated over a week ago

LATLONG()

LatLong from components
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

LEN()

Number of characters in textual value
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

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

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

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

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

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

TOP()

Initial list items
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

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

USERNAME()

User's name
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

USERSETTINGS()

Specified user setting value
S
Written by Steve Coile
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
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

YEAR()

Year from Date, DateTime, or Time
S
Written by Steve Coile
Updated over a week ago