Jump to content
  • Google Sheets will now automatically correct formulas for you


    • 2 minutes

    • 2 minutes

    Although people with access to Microsoft 365's Office suite of applications tend to use Excel Online when they want to use spreadsheet software on the web, another alternative to consider is Google Sheets too. Google regularly updates Sheets with new features and capabilities to entice more customers. Now, it has empowered Sheets to autonomously and intelligently correct formulas for you.


    This capability follows a related one from last year where Google Sheets would automatically suggest formulas to you. The latest update for formula corrections now helps you write complex mathematical and logical calculations with more confidence.


    Formulas corrections are context-aware and enable users to troubleshoot with ease too. Basically, whenever Sheets detects that a formula can be improved, it will offer you a suggestion box with the recommended changes and the associated details. You can then choose to accept or reject the recommendation.


    Although Google hasn't detailed an extensive list of formulas that Sheets can intelligently correct for you, some examples include VLOOKUP errors, missing cells in input range, and locking of ranges when applying formulas across a series of cells. The capability will likely improve with time.


    Formula corrections will be enabled by default, but people who don't want it can head over to Tools > Enable formula corrections to toggle it off. The functionality is available for Google Workspace, G Suite, and Google personal accounts, but it may take several weeks for it to appear generally for these customers.



    Google Sheets will now automatically correct formulas for you

    User Feedback

    Recommended Comments

    There are no comments to display.

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Add a comment...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...