.jpg){kind=link}
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. Check out the functionality in action in the GIF below:
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.