Google Sheets wants to save you from screwing up your formulas

Spreadsheets can become unmanageable pretty quickly, but with some handy formulas, you can crunch those numbers in no time. If that still sounds all too daunting of a task, Sheets makes it easy to discover the tools you need to create your documents. Last year,Google added auto-suggestionsfor certain formulas, and with its latest update, it’s going to stop you from messing them up.

With thelatest update to Sheets, users can take advantage of context-aware corrections, able to identify and assist with fixing any problems you might run into. Google describes them as “intelligent corrections,” which appear in a contextual suggestion box whenever the app detects you might need some help with your formula. These recommendations aren’t required — if you’re certain your spreadsheet is up to snuff, you can reject them at will.

4

Google provided a handful of examples this tool supports, including:

This feature is coming to all Google users, including personal, Workspace, and legacy G Suite accounts. It’s on an extended rollout track, so it may take longer than 15 days to reach everyone.

The Google Sheets logo against a spreadsheet and a glass ceiling

The note-taking app I should have used all along

Broader branding hints at wider paid-tier ambitions

sheets-intelligent-corrections-anim

It’s never been cheaper

More visual changes

Browsers

Not yet, anyway

Boost Mobile sees changes, too

Samsung Notes logo in front of image containing S Pen and devices using Samsung Notes