EXPRESSIONS

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

Madeline Clarke avatar Praveen Seshadri (CEO AppSheet) avatar S
92 articles in this collection
Written by Madeline Clarke, Praveen Seshadri (CEO AppSheet), and Steve Coile
Functions

ABS()

Arithmetic absolute value
S
Written by Steve Coile
Updated yesterday

AND()

Are all true?
S
Written by Steve Coile
Updated this week

ANY()

One arbitrary list item
S
Written by Steve Coile
Updated this week

AVERAGE()

Arithmetic average of list items
S
Written by Steve Coile
Updated this week

CEILING()

Nearest higher integer
S
Written by Steve Coile
Updated this week

CONCATENATE()

Merged text values
S
Written by Steve Coile
Updated over a week ago

COUNT()

Number of list items
S
Written by Steve Coile
Updated this week

DATE()

Date from Date, DateTime, or Time value
S
Written by Steve Coile
Updated this week

DATETIME()

DateTime from Date, DateTime, or Time value
S
Written by Steve Coile
Updated this week

DAY()

Day of month from Date
S
Written by Steve Coile
Updated this week

ENCODEURL()

Text encoded for use in URL
S
Written by Steve Coile
Updated this week

FILTER()

Select rows of table
S
Written by Steve Coile
Updated this week

FIND()

Position of fragment in text
S
Written by Steve Coile
Updated this week

FLOOR()

Nearest lower integer
S
Written by Steve Coile
Updated this week

HERE()

Current location
S
Written by Steve Coile
Updated this week

HOUR()

Hour from Duration
S
Written by Steve Coile
Updated this week

HYPERLINK()

New hyperlink
S
Written by Steve Coile
Updated this week

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

Length of text
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

LONG()

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

LOOKUP()

Column value of select row in table
S
Written by Steve Coile
Updated this week

LOWER()

Text with lower-case letters
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 this week

MIN()

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

MINROW()

Row with least value in column
S
Written by Steve Coile
Updated this week

MINUTE()

Minute of the 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
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

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

Right-most 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 the minute from Duration
S
Written by Steve Coile
Updated over a week ago

SELECT()

Column values of select rows in table
S
Written by Steve Coile
Updated this week

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 temporal value
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 items of list
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()

Text with upper-case letters
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

USERSETTINGS()

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

WEEKDAY()

Day of week from Date
S
Written by Steve Coile
Updated over a week ago

WEEKNUM()

Week of year from Date
S
Written by Steve Coile
Updated over a week ago

YEAR()

Year from Date
S
Written by Steve Coile
Updated over a week ago