AppSheet function list
Here's a list of all the AppSheet functions available by category that can be used when building expressions. See also Expressions: The Essentials
.
| Type | Name | Syntax | Returns |
|---|---|---|---|
|
Conditional
|
IF | IF( logical-expression
, value-if-true
, value-if-false
)
|
Either/or conditional evaluation. Learn more |
|
Conditional
|
IFS | IFS( condition1
, value1
, [ condition2,
value2 ...
])
|
First-match conditional evaluation. Learn more |
|
Conditional
|
SWITCH | SWITCH( expression
, case1
, value1
, [
case2
, value2
...], default
)
|
Choose-one conditional evaluation. Learn more |
|
Date and time
|
DATE | DATE( when
)
|
Date
from Date
, DateTime
, or Time
. Learn more
|
|
Date and time
|
DATETIME | DATETIME( when
)
|
DateTime
from Date
, DateTime
, or Time
. Learn more
|
|
Date and time
|
DAY | DAY( when
)
|
Day of month from Date
, DateTime
, or Time
. Learn more
|
|
Date and time
|
EOMONTH | EOMONTH( when
, offset-months
)
|
Date of last day of a month from Date
or DateTime
. Learn more
|
|
Date and time
|
EOWEEK | EOWEEK( when
)
|
Date of last day of a week from Date
or DateTime
. Learn more
|
|
Date and time
|
EWOMONTH | EWOMONTH( when
, offset-months
)
|
Date of last weekday of a month Date
or DateTime
. Learn more
|
|
Date and time
|
EXTRACTDATES | EXTRACTDATES( text-to-extract-from
)
|
Extract list of dates within a textual value. Learn more |
|
Date and time
|
EXTRACTDATETIMES | EXTRACTDATETIMES( text-to-extract-from
)
|
Extract list of DateTime
values within a textual value. Learn more
|
|
Date and time
|
EXTRACTDURATIONS | EXTRACTDURATIONS( text-to-extract-from
)
|
Extract list of Duration
values within a textual value. Learn more
|
|
Date and time
|
EXTRACTTIMES | EXTRACTTIMES( text-to-extract-from
)
|
Extract list of Time
values within a textual value. Learn more
|
|
Date and time
|
HOUR | HOUR( duration
)
|
Count of hours ( Number
) in Duration
. Learn more
|
|
Date and time
|
ISOWEEKNUM | ISOWEEKNUM( date
)
|
Number of the ISO week of the year for the specified date. Learn more |
|
Date and time
|
MINUTE | MINUTE( duration
)
|
Minute of hour from Duration
. Learn more
|
|
Date and time
|
NOW | NOW()
|
Current date and time. Learn more |
|
Date and time
|
MONTH | MONTH( when
)
|
Month of year from Date, DateTime, or Time. Learn more |
|
Date and time
|
SECOND | SECOND( duration
)
|
Second of minute from Duration
. Learn more
|
|
Date and time
|
TIME | TIME( when
)
|
Time from Date
, DateTime
, or Time
. Learn more
|
|
Date and time
|
TIMENOW | TIMENOW()
|
Current time. Learn more |
|
Date and time
|
TODAY | TODAY()
|
Current date. Learn more |
|
Date and time
|
TOTALHOURS | TOTALHOURS( duration
)
|
Count of hours ( Decimal
) in Duration
. Learn more
|
|
Date and time
|
TOTALMINUTES | TOTALMINUTES( duration
)
|
Count of minutes in Duration
. Learn more
|
|
Date and time
|
TOTALSECONDS | TOTALSECONDS( duration
)
|
Count of seconds in Duration
. Learn more
|
|
Date and time
|
USERTZOFFSET | USERTZOFFSET()
|
User's local time offset from UTC. Learn more |
|
Date and time
|
UTCNOW | UTCNOW()
|
Current time and date in UTC. Learn more |
|
Date and time
|
WEEKDAY | WEEKDAY( when
)
|
Day of week from Date
or DateTime
. Learn more
|
|
Date and time
|
WEEKNUM | WEEKNUM( when
)
|
Week of year from Date
or DateTime
. Learn more
|
|
Date and time
|
WORKDAY | WORKDAY( when
, days
, [ holidays
])
|
Computed date excluding non-work days. Learn more |
|
Date and time
|
YEAR | YEAR( when
)
|
Year from Date
, DateTime
, or Time
. Learn more
|
|
Image
|
SNAPSHOT | SNAPSHOT( deep-link
)
|
Take a snapshot of a view. Learn more |
|
Image
|
TEXT_ICON | TEXT_ICON( text
)
|
Icon from text. Learn more |
|
Informational
|
CONTEXT | CONTEXT( option
)
|
Information about the running app. Learn more |
|
Informational
|
INPUT | INPUT( input-name
, default
)
|
Dynamic input assigned by the user or an action. Learn more |
|
Informational
|
USEREMAIL | USEREMAIL()
|
User's email address. Learn more |
|
Informational
|
USERLOCALE | USERLOCALE()
|
User's locale. Learn more |
|
Informational
|
USERNAME | USERNAME()
|
User's name. Learn more |
|
Informational
|
USERROLE | USERROLE()
|
User's role. Learn more |
|
Informational
|
USERSETTINGS | USERSETTINGS(" user-setting"
)
|
Specified user setting value. Learn more |
|
Link
|
ENCODEURL | ENCODEURL( text
)
|
Encode text for use in URL. Learn more |
|
Link
|
HYPERLINK | HYPERLINK( url
, text
)
|
New hyperlink. Learn more |
|
Link
|
LINKTEXT | LINKTEXT( hyperlink
)
|
Text component of hyperlink. Learn more |
|
Link
|
LINKTOAPP | LINKTOAPP( app-name
)
|
Constructed deep link to an app. Learn more |
|
Link
|
LINKTOFILTEREDVIEW | LINKTOFILTEREDVIEW( view
, filter
)
|
Constructed deep link to a filtered view. Learn more |
|
Link
|
LINKTOFORM | LINKTOFORM( view
, column
, value
, [ column
, value...
], [ app-name
])
|
Constructed deep link to a form. Learn more |
|
Link
|
LINKTOPARENTVIEW | LINKTOPARENTVIEW()
|
Constructed deep link to the parent view. Learn more |
|
Link
|
LINKTOROW | LINKTOROW( key
, view
, [ app-name
])
|
Constructed deep link to a row. Learn more |
|
Link
|
LINKTOVIEW | LINKTOVIEW( view
, [ app-name
])
|
Constructed deep link to a view. Learn more |
|
Link
|
LINKURL | LINKURL( hyperlink
)
|
URL component of hyperlink. Learn more |
|
List
|
ANY | ANY( list
)
|
One arbitrary list item. Learn more |
|
List
|
COUNT | COUNT( list
)
|
Number of list items. Learn more |
|
List
|
IN | IN( item-to-search-for
, list-to-search
)
|
Is item in list? Learn more |
|
List
|
INDEX | INDEX( list
, which-one
)
|
One specific line item. Learn more |
|
List
|
INTERSECT | INTERSECT( list1
, list2
)
|
Items common to two lists. Learn more |
|
List
|
LIST | LIST([ value
...])
|
New list. Learn more |
|
List
|
MAX | MAX( list
)
|
Highest item in a list. Learn more |
|
List
|
MIN | MIN( list
)
|
Lowest item in a list. Learn more |
|
List
|
SORT | SORT( list
, [descending])
|
Sorted list of items. Learn more |
|
List
|
SPLIT | SPLIT( text
, delimiter
)
|
List from text. Learn more |
|
List
|
TOP | TOP( list
, how-many
)
|
Initial list of items. Learn more |
|
List
|
UNIQUE | UNIQUE( list
)
|
Unique items in list. Learn more |
|
Location
|
DISTANCE | DISTANCE( location1
, location2
)
|
Distance between locations. Learn more |
|
Location
|
HERE | HERE()
|
Current location. Learn more |
|
Location
|
LAT | LAT( where
)
|
Latitude component of location. Learn more |
|
Location
|
LATLONG | LATLONG( latitude
, longitude
)
|
LatLong
from components. Learn more
|
|
Location
|
LONG | LONG( where
)
|
Longitude component of location. Learn more |
|
Location
|
XY | XY( x
, y
)
|
XY value based on the coordinates. Learn more |
|
Logical
|
AND | AND( condition1
, condition2
, [ condition3
...])
|
Answer: Are all true? Learn more |
|
Logical
|
NOT | NOT( condition
)
|
Is it false? Learn more |
|
Logical
|
OR | OR( condition1
, condition2
, [ condition3
...])
|
Are any true? Learn more |
|
Math
|
ABS | ABS( x
)
|
Arithmentic absolute value. Learn more |
|
Math
|
AVERAGE | AVERAGE( list
)
|
Arithmetic average of list of numeric values. Learn more |
|
Math
|
CEILING | CEILING( x
)
|
Round up to nearest integer. Learn more |
|
Math
|
DECIMAL | DECIMAL( x
)
|
Decimal from any value. Learn more |
|
Math
|
FLOOR | FLOOR( x
)
|
Round down to nearest integer. Learn more |
|
Math
|
LN | LN( x
)
|
Natural logarithm of a numeric value. Learn more |
|
Math
|
LOG | LOG( x
, [ base
])
|
Logarithm of a numeric value. Learn more |
|
Math
|
LOG2 | LOG2( x
)
|
Base 2 logarithm of a numeric value. Learn more |
|
Math
|
LOG10 | LOG10( x
)
|
Base 10 logarithm of a numeric value. Learn more |
|
Math
|
MOD | MOD( dividend
, divisor
)
|
Arithmetic remainder from integer division. Learn more |
|
Math
|
NUMBER | NUMBER( value
)
|
Number from any value. Learn more |
|
Math
|
POWER | POWER( x
, y
)
|
Arithmetic exponentiation. Learn more |
|
Math
|
RANDBETWEEN | RANDBETWEEN( lower-bound
, upper-bound
)
|
Random integer from range. Learn more |
|
Math
|
ROUND | ROUND( x
)
|
Nearest integer. Learn more |
|
Math
|
SQRT | SQRT( x
)
|
Arithmetic square root. Learn more |
|
Math
|
STDEVP | STDEVP( list
)
|
Arithmetic standard deviation of list items. Learn more |
|
Math
|
SUM | SUM( list
)
|
Arithmetic sum of list items. Learn more |
|
Table
|
FILTER | FILTER( dataset
, row-condition
)
|
Select rows of table or slice. Learn more |
|
Table
|
LOOKUP | LOOKUP( value
, dataset
, column
, return-column
)
|
Get column value from row in table or slice. Learn more |
|
Table
|
MAXROW | MAXROW( dataset
, column
, [ row-condition
])
|
Row with greatest value in column. Learn more |
|
Table
|
MINROW | MINROW( dataset
, column
, [ row-condition
])
|
Row with lowest value in column. Learn more |
|
Table
|
ORDERBY | ORDERBY( keys
, sort-key
, [ descending-order
, [ sort-key
]]...)
|
Sort row references. Learn more |
|
Table
|
REF_ROWS | REF_ROWS( dataset
,
ref-column
)
|
Gather related rows from table or slice. Learn more |
|
Table
|
SELECT | SELECT( dataset-column
, row-condition
, [ distinct-only
])
|
Select rows from a table or slice. Learn more |
|
Table
|
UNIQUEID | UNIQUEID([type])
|
Pseudo-unique ID. Learn more |
|
Text
|
CONCATENATE | CONCATENATE( part
, [ part ...]
)
|
Merged text from parts. Learn more |
|
Text
|
DOMAINOF | DOMAINOF( email
)
|
Extract domain from an email address. Learn more |
|
Text
|
ENDSWITH | ENDSWITH( text-to-search
, search-for
)
|
Does text end with fragment? Learn more |
|
Text
|
EXTRACT | EXTRACT(" text
", text-to-extract-from
)
|
Extract values from text. Learn more |
|
Text
|
EXTRACTDOMAINS | EXTRACTDOMAINS( text-to-extract-from
)
|
Extract list of domain values within a textual value. Learn more |
|
Text
|
EXTRACTEMAILS | EXTRACTEMAILS( text-to-extract-from
)
|
Extract list of Email
values within a textual value. Learn more
|
|
Text
|
EXTRACTHASHTAGS | EXTRACTHASHTAGS( text-to-extract-from
)
|
Extract list of hashtags within a textual value. Learn more |
|
Text
|
EXTRACTMENTIONS | EXTRACTMENTIONS( text-to-extract-from
)
|
Extract list of mentions within a textual value. Learn more |
|
Text
|
EXTRACTNUMBERS | EXTRACTNUMBERS( text-to-extract-from
)
|
Extract list of numeric values within a textual value. Learn more |
|
Text
|
EXTRACTPHONENUMBERS | EXTRACTPHONENUMBERS( text-to-extract-from
)
|
Extract list of phone numbers within a textual value. Learn more |
|
Text
|
EXTRACTPRICES | EXTRACTPRICES( text-to-extract-from
)
|
Extract list of price values within a textual value. Learn more |
|
Text
|
FIND | FIND( search-for
, text-to-search
)
|
Position of fragment in text. Learn more |
|
Text
|
INITIALS | INITIALS( text
)
|
First character of each word. Learn more |
|
Text
|
LEFT | LEFT( text,
how-many
)
|
Left-most characters of text. Learn more |
|
Text
|
LEN | LEN( text
)
|
Number of characters in textual value. Learn more |
|
Text
|
LOWER | LOWER( text
)
|
Convert text to lowercase. Learn more |
|
Text
|
MID | MID( text
, begin-at
, length
)
|
Segment of a string. Learn more |
|
Text
|
OCRTEXT | OCRTEXT([ image-column
])
|
Extract all text from an image. Learn more |
|
Text
|
RIGHT | RIGHT( text,
how-many
)
|
Right-most consecutive characters from a textual value. Learn more |
|
Text
|
STARTSWITH | STARTSWITH( text-to-search,
search-for
)
|
Does text begin with fragment? Learn more |
|
Text
|
SUBSTITUTE | SUBSTITUTE( text-to-search
, search-for
, replace-with
)
|
Text with replacements Learn more |
|
Text
|
TEXT | TEXT( value,
[ format
])
|
ormatted text from the first argument.. Learn more |
|
Text
|
TRIM | TRIM( value
)
|
Format as text. Learn more |
|
Text
|
UPPER | UPPER( text
)
|
Convert text to uppercase. Learn more |
|
Yes/No
|
CONTAINS | CONTAINS( text-to-search
, text-to-search-for
)
|
Does text contain fragment? Learn more |
|
Yes/No
|
EXTRACTCHOICE | EXTRACTCHOICE( text-to-extract-from
)
|
Extract one Yes/No
value within textual value. Learn more
|
|
Yes/No
|
ISBLANK | ISBLANK( value
)
|
Is value absent? Learn more |
|
Yes/No
|
ISNOTBLANK | ISNOTBLANK( value
)
|
Is value present? Learn more |
| Try your keywords on Google Web Search . | |||
