M
Back to website
Learn
Reference
Reference
Overview
REFERENCE
Glossary
Components
Functions
ABS
ADD_COLUMN
ADD_COLUMN_AFTER
ADD_COLUMN_BEFORE
ADD_COMPONENT
ADD_FIRST_ROW
ADD_RECORDS
ADD_ROW
ADD_ROW_AFTER
ADD_ROW_BEFORE
ADDRESS
AND
ANIMATION_STOP
APPEND
APPEND_RANGE
ARRAYFORMULA
AUG
AVERAGE
AVERAGEIF
AVERAGEIFS
BASE_ADD
BASE_DELETE
BASE_RENAME
BASES
BROWSER_TOPLEVEL_URL
BROWSER_URL
CACHE
CACHE_CLEAR
CACHE_ENTRIES
CACHE_GET
CACHE_KEYS
CACHE_SET
CACHES
CAST
CEILING
CELL
CHAR
CHOOSE
CLEAR_CELL
CLEAR_CELL_VALUE
COLUMN
COLUMN_OF
COLUMNS
CONCAT_ROWS
CONCATENATE
CONVERT_DATETIME
COPY_COMPONENT
COPY_COMPONENTS
COPY_STYLE_IF
COUNT
COUNT_RECORDS
COUNT_ROWS
COUNTIF
COUNTIFS
CURRENT_PAGE
CURRENT_USER
CURRENT_UTC_OFFSET
DATE
DATETIMEVALUE
DATEVALUE
DAY
DEBOUNCE
DECODE_URL
DELETE
DELETE_CACHE
DELETE_COLUMN
DELETE_COLUMNS
DELETE_EXT
DELETE_MAIN_COLUMNS
DELETE_MAIN_ROWS
DELETE_RECORDS
DELETE_RECORDS_BY_ID
DELETE_ROW
DELETE_ROW_AT
DELETE_ROWS
DND_APPEND
DND_COPY
DND_MOVE
DND_SWAP
DO
DO_AFTER
DO_EVERY
DO_IF_CHANGED
DO_PARALLEL
DOWNLOAD_AS_CSV
DOWNLOAD_AS_EXCEL
E
E_ITEM_INDEX
EMOJI
EMOJI_SEARCH
EMOJIS
ENCODE_URL
ENV
EOMONTH
EXCLUDE_COLUMNS
EXTRACT
EXTRACT_COLUMNS
EXTRACT_TO
FILE
FILES
FILTER
FILTER_IN_SET
FIND
FIND_REPLACE
FLIP_FRAME
FLOOR
FORMAT_DATE
FORMAT_NUMBER
FORMULAEVAL
FORMULATEXT
FRAME
FROM_BASE64
FROM_EMOJI
FROM_JSON
FROM_TIMESTAMP
GET
GET_3RD_PARTY_LOGIN_INFO
GET_CELL
GET_COOKIE
GET_EXT
GET_QUERY_PARAMS
GET_RECORDS
GOTO_PAGE
GRAB
GRAB_LIST
GROUP_BY
GUID
HAS_COLUMN
HAS_COLUMNS
HAS_COOKIE
HASH_HMAC_SHA1
HIDE_ALL_OVERLAYS
HIDE_OVERLAY
HIDE_TOPMOST_OVERLAY
HLOOKUP
HOUR
IF
IFERROR
INDEX
IS_EMOJI
IS_ERROR
IS_LOADING
IS_LOGGED_IN_3RD_PARTY
IS_NULL
IS_STREAMING
ISBLANK
JOIN
JOIN_FRAMES
JOIN_FRAMES_CROSS_PRODUCT
JOIN_FRAMES_FULL
JOIN_FRAMES_LEFT
JOIN_FRAMES_RIGHT
JSON
JSON_PRETTY
LAST_BY
LEFT
LEN
LOGIN_WITH_3RD_PARTY
LOGOUT
LOGOUT_3RD_PARTY
LOWER
MATCH
MAX
MID
MIN
MINUTE
MOD
MONTH
NOT
NOW
OAUTH_SIGN
OR
PARSE_TIMESTAMP
PATCH
PATCH_EXT
PATH
POST
POST_EXT
POST_FORM
POWER
PRINT_CELLS
PRINT_RANGES
PUT
PUT_EXT
RANDBETWEEN
RANDOM
RANGE
RANGE_VALUES
REGEXEXTRACT
REGEXMATCH
REGEXREPLACE
REMOVE_ALL_COMPONENTS
REMOVE_COMPONENT
REMOVE_COMPONENTS_OF
REPLACE
RESTART
RIGHT
ROUND
ROW
ROW_AT
ROWS_AT
SAMPLE
SAMPLE_PERCENT
SAVE_FILE
SAVE_FILES
SECOND
SEND_TO_PARENT
SERIES
SET_BINDING
SET_CELL
SET_CELL_VALUE
SET_COOKIE
SET_FRAME_CELL
SET_RANGE_BINDING
SHOW_OVERLAY
SORT
SPLIT
START
STOP
SUBMIT_FORM
SUBSTITUTE
SUM
SUMIF
SUMIFS
TABLE_ADD_ROWS
TABLE_COLUMNS
TABLE_DELETE
TABLE_DELETE_COLUMNS
TABLE_DELETE_COLUMNS_EXCEPT
TABLE_DELETE_ROWS
TABLE_DELETE_ROWS_BY_ID
TABLE_RENAME
TABLE_ROW_COUNT
TABLE_ROWS
TABLE_SET_COLUMN_ORDER
TABLE_SPEC
TABLE_UPDATE_ROWS
TABLE_UPDATE_ROWS_BY_ID
TABLE_UPSERT_ROWS
TABLES
TEXT_TEMPLATE
TEXTJOIN
TIME
TIMESTAMP
TIMEVALUE
TO_BASE64
TO_EMOJI
TO_UTC_AT_OFFSET
TODAY
TOGGLE
TOGGLE_OVERLAY
TRANSPOSE
TRIM
TWEEN
TYPE_OF
UPDATE_COLUMN
UPDATE_FIRST_ROW
UPDATE_LAST_ROW
UPDATE_RECORDS
UPDATE_RECORDS_BY_ID
UPDATE_ROW
UPLOAD_FILE
UPPER
UPSERT_RECORDS
UPSERT_ROW
URL
VIEWPORT
VLOOKUP
WEEKDAY
WRAP
YEAR
Blocks
Data Types
Previous – Functions
HLOOKUP
Next – Functions
IF
Contents