v4.14
Formulas you can name, faster pasting from Excel, and the start of the v1 API's retirement.
-
NewFormulas
LET and LAMBDA work in every cell
Name an intermediate result once and reuse it:
=LET(rate, B2/12, PMT(rate, 360, -C2)). A LAMBDA saved to a workbook shows up in autocomplete for everyone with edit access, with the name of the person who wrote it. -
ImprovedGrid and editing
Pasting 50,000 rows from Excel takes about 2 seconds
It took 11 on the same test sheet in v4.13 (a 14-column ledger, Chrome on a 2022 laptop). Formatting is now applied after the values land instead of cell by cell.
-
FixedCollaboration
Comments follow their cell through a sort
Sorting a range left comments on the old row number, attached to someone else's data. Reported by 31 teams; it has been wrong since comments launched in v3.2.
-
DeprecatedAPI
The v1
/sheets/{id}/valuesendpoint is being retiredIt becomes read-only on 1 February 2027 and stops answering on 1 May 2027. The v2
/rangesendpoint does the same job and accepts the same tokens. Owners of tokens that called v1 in the last 30 days have been emailed.