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 and Expression Builder

Tools to help construct and test expressions.

Written by Santiago Uribe Montoya
Updated over a week ago

Column Value Expressions

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

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.

Written by Santiago Uribe Montoya
Updated over a week ago

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

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.

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.

Written by Santiago Uribe Montoya
Updated over a week ago

Math Expressions

Use mathematical expressions to make calculations.

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.

Written by Santiago Uribe Montoya
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.

Written by Santiago Uribe Montoya
Updated over a week ago

Backward Compatibility Expressions

Learn about obsolete expressions and what we still support.

Written by Santiago Uribe Montoya
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

How to determine if an input from the user is required before the record can be saved.

Written by Santiago Uribe Montoya
Updated over a week ago

Editable_If Column Constraint

How to determine if a column is editable under certain conditions.

Written by Santiago Uribe Montoya
Updated over a week ago

Show_If Column Constraint

Conditionally show or hide a column depending on earlier values in a form.

Written by Santiago Uribe Montoya
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

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

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