λ Lambdas
Community lambdas.
Copyable definitions. Tested. Tagged. Star the ones you use.
REGEX.CAPTURE
(text, pattern, [group])
Capture a named regex group from a cell. Returns #N/A on no match, never the input.
TEXT.JSON.PARSE
(json, [path])
Parse a JSON string. Optional JSONPath ($..items[*].name). Returns spilled array.
DATE.WORKDAYS
(start, end, [holidays])
Working-day count excluding weekends and an optional holidays range. Inclusive of both endpoints.
TEXT.SLUGIFY
(s, [sep])
Lowercase, strip diacritics, replace non-alnum with the separator. Useful for stable keys.
PIVOT.CAST
(table, rows, cols, value, [agg])
Pivot a long table to wide. agg defaults to SUM.
PIVOT.MELT
(table, id_cols)
Unpivot a wide table into a tall one. Keeps id columns, melts everything else into name/value rows.
STATS.QUANTILE
(data, p, [method])
Interpolated quantile using a configurable method (linear, lower, higher, midpoint).
IRR.BISECT
(cashflows, [guess])
Internal rate of return via bisection — more stable than the native IRR for irregular flows.
SIM.MONTECARLO
(n, fn)
Run n samples of a parameterless lambda, return the array of results.
STATS.ZSCORE
(data)
Z-score normalize a 1D array. Skips empty cells.
GEO.HAVERSINE
(lat1, lon1, lat2, lon2)
Great-circle distance in km between two lat/lon pairs.
BYROW.IF
(array, predicate)
Filter rows of a 2D array using a row-wise lambda. Equivalent to BYROW + FILTER, but eager.