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, 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.
Know the Pro boundary
Local computation stays free. Future enriched functions that call Functable services will be licensed through Pro.
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
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