Many more functions
The StretchSheets formula engine gained roughly 110 additional functions, closing the biggest gap against Excel and Google Sheets. New support spans every common family:
| Family | Examples now supported |
|---|---|
| Math & trig | PI, SIN/COS/TAN (and inverse/hyperbolic), EXP, LN/LOG/LOG10, MROUND, GCD/LCM, SUMPRODUCT, RAND/RANDBETWEEN |
| Statistics | LARGE/SMALL, PERCENTILE, QUARTILE, MODE, MAXIFS/MINIFS, CORREL, SLOPE, FORECAST, GEOMEAN |
| Text | TEXTJOIN, TEXTSPLIT, TEXTBEFORE/TEXTAFTER, CHAR/CODE, CLEAN, EXACT, NUMBERVALUE |
| Date & time | EOMONTH, EDATE, DATEDIF, NETWORKDAYS, WORKDAY, WEEKNUM, HOUR/MINUTE/SECOND |
| Lookup & reference | HLOOKUP, LOOKUP, OFFSET, INDIRECT, ROW/COLUMN, ROWS/COLUMNS, CHOOSECOLS/CHOOSEROWS, ADDRESS |
| Information (IS…) | ISBLANK, ISNUMBER, ISTEXT, ISERROR, ISFORMULA, TYPE, ERROR.TYPE |
These work with the engine's existing dynamic arrays, so functions like TEXTSPLIT, CHOOSECOLS, and OFFSET spill their results across cells. A parsing fix also makes dotted-name functions (for example STDEV.P, PERCENTILE.INC, RANK.EQ) resolve correctly.
Availability
Rolling out. The expanded library ships with the StretchSheets calculation engine and is enabled per account. Once it is on for your workspace, the new functions evaluate live; the in-app formula-support summary updates to reflect the broader library.
Good to know
- Function coverage is now roughly 230 of the most-used spreadsheet functions. A short list of specialised families (regex text, statistical distributions, database functions) is still on the roadmap and reported as "cataloged" until implemented.
Was this helpful?
Help us improve this article
Use these controls to share whether this answer solved the issue. Feedback helps prioritize updates to StretchSuite Support.