Google Sheets Now Suggests Automatic Formulas and Functions According to the Worksheet Context

For the Google Sheets web application, there are often allegations (complaints might be the better description) that it is a much simpler version of spreadsheets compared to Microsoft Excel.

Since this service is free, we certainly cannot expect a large number of features and functions that are part of the existing Office suites, but Google is working intensively to improve Google Sheets.

Google Sheets Gets a New Update

It has been announced these days that Google Sheets is getting a new update that will introduce automated suggestions for formulas and functions in spreadsheets. The suggestions will work based on the context of displaying the tables and data in the worksheet. Google states that data analysis is done much faster in this way, and with the new application of machine learning models for various, random forms of data entered, users will get an automatic suggestion for using formulas.

The news of the update was published as a post on Google’s blog and its implementation began on August 25, and the option is expected to become available to all users within a two-week period. Once the required update has been performed, formula suggestions will be available to users as a default. If users want to disable the automatic usage of formula suggestions, they can do so by going to the “Tools” menu and unchecking the “Enable formula suggestions” box.

Formula suggestions are derived automatically from the context of the table and its data and, at the same time, the range of affected data is automatically marked. In a situation where we place ourselves in a cell below the list of numbers or values in Google Sheets, a box with a formula suggestion and a range of data cells will automatically open.

What Did the Tests Show?

Tests have shown that it really is a great tool. When we have, for example, one column of numerical data, users are offered the option of adding or calculating the average of the marked data by placing it in a cell below it. After the free-choice proposal of the summation of data (SUM) was accepted, further placement in the cell below the obtained result and re-entering the sign “=” to enter the new formula of the SUM option was no longer because it was already used for the same data sequence.

In formula selection situations, Google Sheets looks not only at the history of each user’s most commonly used formulas but also at the specific context of each new table and the ways in which the data is presented through column headers and headings.

Maybe it is not the right time or place, but Google Sheets proved effective in calculating the VIG (Vigorish) margin, i.e. the house edge, in gambling/sports betting at all casinos labeled as the best Booongo online casino (or some other online casinos offering games of splendid software providers). Every gambler or sports bettor should have a few spreadsheet formulas at his disposal. Spreadsheets allow you to organize, manage, explore, and visualize data in a logical manner. You can use Google Sheets to load and manipulate data, as well as simulate games, size bets, track schedules, detect hedging possibilities, and more – if you commit a little time. But more on that in a later article…