Intelligent corrections for formulas in Google Sheets

 

Last year, Google launched formula suggestions in Sheets, which recommend formulas for specific cells based on the data you are analyzing. Now, you can write formulas faster and with higher confidence with formula corrections. These intelligent, context-aware corrections help you improve and troubleshoot many different kinds 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. 

End users: This feature will be available by default and can be disabled by going to Tools > Enable formula corrections or from the three-dot menu of the suggestion dialog box. 

Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers, and users with personal Google Accounts. 


Google Workspace Updates

Comments

Popular posts from this blog

Use Vault for Gmail Confidential Messages and Jamboard Files

Access well-known educational technology tools straight from Google Classroom.

Zoom’s Work Transformation Summit on Jan. 19: Fresh Approaches for Moving Forward