Google Sheets wants to save you from screwing up your formulas

2022-04-26 07:53:43 By : Mr. Bruce zhou

Intelligent corrections aim to catch your mistakes before they impact any data

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-suggestions for certain formulas, and with its latest update, it's going to stop you from messing them up.

With the latest 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.

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.

Will has been an Android enthusiast since he got his first smartphone in 2011. He loves watching movies, has a never-ending backlog of video games, and produces podcasts in his spare time. He lives in Buffalo, NY and is willing to give you chicken wing recommendations at any time. Just ask.