Intelligent corrections for formulas in Google Sheets

26/05/2022

Table of contents

Quick Summary

Last year, Google introduced formula suggestions in Sheets, which suggests formulas for specific cells based on the data you're analyzing. Now you can write the above formula Google sheets Faster and more reliable with recipe correction. These smart, context-aware edits help you improve and troubleshoot many different types of formulas. Some examples include:

VLOOKUP errors
Missing cells in range input
Locking ranges when applying formulas across cells

Whenever you insert a formula that Sheets detects may be improved, a suggestion box will appear with details on a new version that can replace the current formula, including the ability to accept or reject it.

For example, the above correction helps users when writing VLOOKUP functions, which only return values to the right of the matched cell. The correction suggests a combination of INDEX and MATCH functions to reverse the column order in the formula.

Getting started

Admin: There is no admin control for these features.
End users: This feature will be available by default and can be disabled by going to Tools > Enable formula editing or from the three-dot menu of the suggestions dialog. Access the Help Center to learn more about using formulas and functions in Google Sheets.