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 row. 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(text-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, select-row?) | 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, [select-row?]) | Row with greatest value in column. Learn more |
| Table | MINROW | MINROW(dataset, column, [select-row?]) | 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, select-row?, [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, text-to-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(text-to-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. | |||