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
150 articles in this collection
Written by Santiago Uribe Montoya, Tony Fader, Praveen Seshadri (CEO AppSheet) and 3 others
Functions

ABS()

Arithmetic absolute value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

AND()

Are all true?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ANY()

One arbitrary list item
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

APP()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

AVERAGE()

Arithmetic average of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CEILING()

Nearest higher integer
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CONCATENATE()

Merged text from parts
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CONTAINS()

Does text contain fragment?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CONTEXT()

Information about the running app.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

COUNT()

Number of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DATE()

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

DATETIME()

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

DAY()

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

DECIMAL()

Decimal from any value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DISTANCE()

Distance between locations
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ENDSWITH()

Does text end with fragment?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EOMONTH()

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

EOWEEK()

Date of last day of a week from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EWOMONTH()

Date of last weekday of a month from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ENCODEURL()

Text encoded for use in URL
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACT()

Extract values from text.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTCHOICE()

Extract one Yes/No value within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDATES()

Extract list of dates within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDATETIMES()

Extract list of DateTime values within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDOMAINS()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDURATIONS()

Extract list of Duration values within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTEMAILS()

Extract list of Email values within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTHASHTAGS()

Extract list of hashtags within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTMENTIONS()

Extract list of mentions within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTNUMBERS()

Extract list of numeric values within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

EXTRACTPHONENUMBERS()

Extract list of phone numbers within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

EXTRACTPRICES()

Extract list of Price values within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

EXTRACTTIMES()

Extract list of Time values within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

FILTER()

Select rows of table or slice
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

FIND()

Position of fragment in text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

FLOOR()

Nearest lower integer
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_AT()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_FROM()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_WITH()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GETX()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GETY()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

HERE()

Current location
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

HYPERLINK()

New hyperlink
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

HOUR()

Hour of day from Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

IF()

Either/or conditional evaluation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

IFS()

First-match conditional evaluation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

IN()

Is item in list?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

INDEX()

One specific list item
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

INITIALS()

First character of each word
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ISBLANK()

Is value absent?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ISNOTBLANK()

Is value present?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

INTERSECT()

Items common to two lists
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LATLONG()

LatLong from components
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LAT()

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

LEFT()

Left-most characters of text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTEXT()

Text component of hyperlink
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOAPP()

Constructed deep link to app
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOFORM()

Constructed deep link to form
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOROW()

Constructed deep link to row
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOVIEW()

Constructed deep link to view
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKURL()

URL component of hyperlink
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LEN()

Number of characters in textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LIST()

New list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LN()

Natural logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOG()

Logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOG2()

Base 2 logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOG10()

Base 10 logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LONG()

Longitude component of location
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOOKUP()

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

LOWER()

Convert text to lowercase.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MAX()

Highest item in list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MAXROW()

Row with greatest value in column
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MID()

Characters from text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MIN()

Lowest item in list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MINROW()

Row with lowest value in column
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MINUTE()

Minute of hour from Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MOD()

Arithmetic remainder from integer division
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MONTH()

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

NOT()

Is it false?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

NOW()

Current date & time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

NUMBER()

Number from any value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

OCRTEXT()

Extract all text from an image
Tony Fader avatar
Written by Tony Fader
Updated over a week ago

OR()

Are any true?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ORDERBY()

Sort row references
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

POWER()

Arithmetic exponentiation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

RANDBETWEEN()

Random integer from range
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

REF_ROWS()

Gather related rows from table or slice
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

RIGHT()

Rightmost characters of text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ROUND()

Nearest integer
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SECOND()

Second of minute from Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SELECT()

Gather column values from row in table or slice
Steve Coile avatar
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
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SORT()

Sorted list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SQRT()

Arithmetic square root
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

STARTSWITH()

Does text begin with fragment?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

STDEVP()

Arithmetic standard deviation of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SUBSTITUTE()

Text with replacements
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SUM()

Arithmetic sum of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SWITCH()

Chose-one conditional evaluation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TEXT()

Format as text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TEXT_ICON()

Icon from text
Steve Coile avatar
Written by Steve Coile
Updated yesterday

TIME()

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

TIMENOW()

Current time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TODAY()

Current date
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOTALHOURS()

Count of hours in Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOP()

Initial list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOTALMINUTES()

Count of minutes in Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOTALSECONDS()

Count of seconds in Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TRIM()

Text with extraneous spaces removed
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UNIQUE()

Unique items in list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UNIQUEID()

Pseudo-unique ID
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UPPER()

Convert text to uppercase.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERNAME()

User's name
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USEREMAIL()

User's email address
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERLOCALE()

User's locale
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERROLE()

Get assigned role of approved user
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UTCNOW()

Current date & time in UTC
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERSETTINGS()

Specified user setting value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

WEEKDAY()

Day of week from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

WEEKNUM()

Week of year from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

WORKDAY()

Computed date excluding non-work days
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

XY()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

YEAR()

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