Google has announced that Google Sheets is getting the ability to intelligently suggest formulas and functions for your spreadsheet, based on the data you’re trying to analyze. For example, typing “=” into a cell below a list of numbers will pop up a box that lets you automatically add the numbers together, find their average, and more.
From my admittedly simple tests, it seems to be a pretty smart system. For example, with one column of data, it suggested that I could be looking for either the sum or average of the numbers. After I chose the sum and moved down to the next cell, it only suggested finding the average for the same range of numbers, not including the sum I’d just calculated. It’s a simple thing, keeping track of what’s data…
