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.

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.

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.

Written by Steve Coile
Updated over a week ago

Dereference Expressions

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

Written by Steve Coile
Updated over a week ago

Math Expressions

Calculate numeric values from other numeric values.

Written by Steve Coile
Updated over a week ago

List Expressions

List expressions use and/or produce lists of values.

Written by Steve Coile
Updated over a week ago

Text Expressions

Text expressions use and/or produce textual values.

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

Other Expressions

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

Written by Steve Coile
Updated over a week ago

Backward Compatibility Expressions

Learn about obsolete expressions and what we still support.

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.

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

Written by Steve Coile
Updated over a week ago

List Addition

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

Written by Steve Coile
Updated over a week ago

List Dereference

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

Written by Steve Coile
Updated over a week ago

List from Expressions

Create a list from the results of expressions.

Written by Steve Coile
Updated over a week ago

List from Table-Column Reference

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

Written by Steve Coile
Updated over a week ago

List from Values

Create a list from raw values.

Written by Steve Coile
Updated over a week ago

List Functions

Create lists using functions.

Written by Steve Coile
Updated over a week ago

List Subtraction

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

Written by Steve Coile
Updated over a week ago

ABS()

Arithmetic absolute value

Written by Steve Coile
Updated over a week ago

AND()

Are all true?

Written by Steve Coile
Updated over a week ago

ANY()

One arbitrary list item

Written by Steve Coile
Updated over a week ago

APP()

Written by Steve Coile
Updated over a week ago

AVERAGE()

Arithmetic average of list items

Written by Steve Coile
Updated over a week ago

CEILING()

Nearest higher integer

Written by Steve Coile
Updated over a week ago

CONCATENATE()

Merged text from parts

Written by Steve Coile
Updated over a week ago

CONTAINS()

Does text contain fragment?

Written by Steve Coile
Updated over a week ago

CONTEXT()

Information about the running app.

Written by Steve Coile
Updated over a week ago

COUNT()

Number of list items

Written by Steve Coile
Updated over a week ago

DATE()

Date from Date, DateTime, or Time

Written by Steve Coile
Updated over a week ago

DATETIME()

DateTime from Date, DateTime, or Time

Written by Steve Coile
Updated over a week ago

DAY()

Day of month from Date, DateTime, or Time

Written by Steve Coile
Updated over a week ago

DECIMAL()

Decimal from any value

Written by Steve Coile
Updated over a week ago

DISTANCE()

Distance between locations

Written by Steve Coile
Updated over a week ago

ENCODEURL()

Text encoded for use in URL

Written by Steve Coile
Updated over a week ago

ENDSWITH()

Does text end with fragment?

Written by Steve Coile
Updated over a week ago

EOMONTH()

Date of last day of a month from Date or DateTime

Written by Steve Coile
Updated over a week ago

EOWEEK()

Date of last day of a week from Date or DateTime

Written by Steve Coile
Updated over a week ago

EWOMONTH()

Date of last weekday of a month from Date or DateTime

Written by Steve Coile
Updated over a week ago

EXTRACT()

Extract values from text.

Written by Steve Coile
Updated over a week ago

EXTRACTCHOICE()

Extract one Yes/No value within textual value

Written by Steve Coile
Updated over a week ago

EXTRACTDATES()

Extract list of dates within textual value

Written by Steve Coile
Updated over a week ago

EXTRACTDATETIMES()

Extract list of DateTime values within textual value

Written by Steve Coile
Updated over a week ago

EXTRACTDOMAINS()

Written by Steve Coile
Updated over a week ago

EXTRACTDURATIONS()

Extract list of Duration values within textual value

Written by Steve Coile
Updated over a week ago

EXTRACTEMAILS()

Extract list of Email values within textual value

Written by Steve Coile
Updated over a week ago

EXTRACTHASHTAGS()

Extract list of hashtags within textual value

Written by Steve Coile
Updated over a week ago

EXTRACTMENTIONS()

Extract list of mentions within textual value

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

Written by Steve Coile
Updated over a week ago

FIND()

Position of fragment in text

Written by Steve Coile
Updated over a week ago

FLOOR()

Nearest lower integer

Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_AT()

Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_FROM()

Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_WITH()

Written by Steve Coile
Updated over a week ago

GETX()

Written by Steve Coile
Updated over a week ago

GETY()

Written by Steve Coile
Updated over a week ago

HERE()

Current location

Written by Steve Coile
Updated over a week ago

HYPERLINK()

New hyperlink

Written by Steve Coile
Updated over a week ago

HOUR()

Hour of day from Duration

Written by Steve Coile
Updated over a week ago

IF()

Either/or conditional evaluation

Written by Steve Coile
Updated over a week ago

IFS()

First-match conditional evaluation

Written by Steve Coile
Updated over a week ago

IN()

Is item in list?

Written by Steve Coile
Updated over a week ago

INDEX()

One specific list item

Written by Steve Coile
Updated over a week ago

INITIALS()

First character of each word

Written by Steve Coile
Updated over a week ago

INPUT()

Specify a dynamic input that is assigned by the user or an action

Written by Praveen Seshadri
Updated over a week ago

INTERSECT()

Items common to two lists

Written by Steve Coile
Updated over a week ago

ISBLANK()

Is value absent?

Written by Steve Coile
Updated over a week ago

ISNOTBLANK()

Is value present?

Written by Steve Coile
Updated over a week ago

LAT()

Latitude component of location

Written by Steve Coile
Updated over a week ago

LATLONG()

LatLong from components

Written by Steve Coile
Updated over a week ago

LEFT()

Left-most characters of text

Written by Steve Coile
Updated over a week ago

LEN()

Number of characters in textual value

Written by Steve Coile
Updated over a week ago

LINKTEXT()

Text component of hyperlink

Written by Steve Coile
Updated over a week ago

LINKTOAPP()

Constructed deep link to app

Written by Steve Coile
Updated over a week ago

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view

Written by Steve Coile
Updated over a week ago

LINKTOFORM()

Constructed deep link to form

Written by Steve Coile
Updated over a week ago

LINKTOPARENTVIEW()

Constructed deep link to parent view.

L

Written by Liz Lynch
Updated over a week ago

LINKTOROW()

Constructed deep link to row

Written by Steve Coile
Updated over a week ago

LINKTOVIEW()

Constructed deep link to view

Written by Steve Coile
Updated over a week ago

LINKURL()

URL component of hyperlink

Written by Steve Coile
Updated over a week ago

LIST()

New list

Written by Steve Coile
Updated over a week ago

LN()

Natural logarithm of a numeric value

Written by Steve Coile
Updated over a week ago

LOG()

Logarithm of a numeric value

Written by Steve Coile
Updated over a week ago

LOG2()

Base 2 logarithm of a numeric value

Written by Steve Coile
Updated over a week ago

LOG10()

Base 10 logarithm of a numeric value

Written by Steve Coile
Updated over a week ago

LONG()

Longitude component of location

Written by Steve Coile
Updated over a week ago

LOOKUP()

Get column value from row in table or slice

Written by Steve Coile
Updated over a week ago

LOWER()

Convert text to lowercase.

Written by Steve Coile
Updated over a week ago

MAX()

Highest item in list

Written by Steve Coile
Updated over a week ago

MAXROW()

Row with greatest value in column

Written by Steve Coile
Updated over a week ago

MID()

Characters from text

Written by Steve Coile
Updated over a week ago

MIN()

Lowest item in list

Written by Steve Coile
Updated over a week ago

MINROW()

Row with lowest value in column

Written by Steve Coile
Updated over a week ago

MINUTE()

Minute of hour from Duration

Written by Steve Coile
Updated over a week ago

MOD()

Arithmetic remainder from integer division

Written by Steve Coile
Updated over a week ago

MONTH()

Month of year from Date, DateTime, or Time

Written by Steve Coile
Updated over a week ago

NOT()

Is it false?

Written by Steve Coile
Updated over a week ago

NOW()

Current date & time

Written by Steve Coile
Updated over a week ago

NUMBER()

Number from any value

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?

Written by Steve Coile
Updated over a week ago

ORDERBY()

Sort row references

Written by Steve Coile
Updated over a week ago

POWER()

Arithmetic exponentiation

Written by Steve Coile
Updated over a week ago

RANDBETWEEN()

Random integer from range

Written by Steve Coile
Updated over a week ago

REF_ROWS()

Gather related rows from table or slice

Written by Steve Coile
Updated over a week ago

RIGHT()

Rightmost characters of text

Written by Steve Coile
Updated over a week ago

ROUND()

Nearest integer

Written by Steve Coile
Updated over a week ago

SECOND()

Second of minute from Duration

Written by Steve Coile
Updated over a week ago

SELECT()

Gather column values from row in table or slice

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

SPLIT()

List from text

Written by Steve Coile
Updated over a week ago

SORT()

Sorted list items

Written by Steve Coile
Updated over a week ago

SQRT()

Arithmetic square root

Written by Steve Coile
Updated over a week ago

STARTSWITH()

Does text begin with fragment?

Written by Steve Coile
Updated over a week ago

STDEVP()

Arithmetic standard deviation of list items

Written by Steve Coile
Updated over a week ago

SUBSTITUTE()

Text with replacements

Written by Steve Coile
Updated over a week ago

SUM()

Arithmetic sum of list items

Written by Steve Coile
Updated over a week ago

SWITCH()

Chose-one conditional evaluation

Written by Steve Coile
Updated over a week ago

TEXT()

Format as text

Written by Steve Coile
Updated over a week ago

TEXT_ICON()

Icon from text

Written by Steve Coile
Updated over a week ago

TIME()

Time from Date, DateTime, or Time

Written by Steve Coile
Updated over a week ago

TIMENOW()

Current time

Written by Steve Coile
Updated over a week ago

TODAY()

Current date

Written by Steve Coile
Updated over a week ago

TOTALHOURS()

Count of hours in Duration

Written by Steve Coile
Updated over a week ago

TOP()

Initial list items

Written by Steve Coile
Updated over a week ago

TOTALMINUTES()

Count of minutes in Duration

Written by Steve Coile
Updated over a week ago

TOTALSECONDS()

Count of seconds in Duration

Written by Steve Coile
Updated over a week ago

TRIM()

Text with extraneous spaces removed

Written by Steve Coile
Updated over a week ago

UNIQUE()

Unique items in list

Written by Steve Coile
Updated over a week ago

UNIQUEID()

Pseudo-unique ID

Written by Steve Coile
Updated over a week ago

UPPER()

Convert text to uppercase.

Written by Steve Coile
Updated over a week ago

USEREMAIL()

User's email address

Written by Steve Coile
Updated over a week ago

USERLOCALE()

User's locale

Written by Steve Coile
Updated over a week ago

USERNAME()

User's name

Written by Steve Coile
Updated over a week ago

USERROLE()

Get assigned role of approved user

Written by Steve Coile
Updated over a week ago

USERSETTINGS()

Specified user setting value

Written by Steve Coile
Updated over a week ago

UTCNOW()

Current date & time in UTC

Written by Steve Coile
Updated over a week ago

WEEKDAY()

Day of week from Date or DateTime

Written by Steve Coile
Updated over a week ago

WEEKNUM()

Week of year from Date or DateTime

Written by Steve Coile
Updated over a week ago

WORKDAY()

Computed date excluding non-work days

Written by Steve Coile
Updated over a week ago

XY()

Written by Steve Coile
Updated over a week ago

YEAR()

Year from Date, DateTime, or Time

Written by Steve Coile
Updated over a week ago