Functable docs
Function reference for the formulas Google Sheets™ is missing.
Install a focused add-on, type the formula into a cell, and use the docs here for syntax, arguments, return values, examples, and edge behavior.
Install by family
Timezone Toolkit, PARSEJSON, GROUPBY / PIVOTBY, FUZZYMATCH, Phone Toolkit, and NAMESPLIT are separate Google Workspace™ Marketplace listings so each spreadsheet gets only what it needs.
Use native formulas
Functions are entered directly into cells and can be copied, filled, nested, and pointed at ranges.
Every function is free
All Functable functions are free and unlimited. Install the add-ons you need without a subscription or per-seat fees.
Families
Choose a reference
Timezone Toolkit
29 documented functions
DST-aware time zone conversion for Google Sheets™. Convert between zones, read offsets and DST, plan meetings, and look up zones with 29 TZ_ functions.
Open docs
ParseJSON
1 documented function
Extract values from JSON strings directly in Google Sheets™ with JSONPath formulas — dot paths, array indexes, wildcards, and filters.
Open docs
GROUPBY / PIVOTBY
4 documented functions
Build dynamic summary and pivot tables in Google Sheets™ with formula-first GROUPBY, PIVOTBY, and namespaced GB_ aliases.
Open docs
FUZZYMATCH
12 documented functions
Find close-enough names, labels, and IDs with fuzzy similarity, match, lookup, and namespaced FM_ formulas.
Open docs
Phone Toolkit
8 documented functions
Format, validate, and identify phone numbers in Google Sheets™ with local libphonenumber-powered PHONE_ formulas.
Open docs
NAMESPLIT
26 documented functions
Split contact names into first, middle, last, title, suffix, confidence, and formatted outputs with formula-first Google Sheets™ functions.
Open docs