Google Sheets’ formula suggestions are like autofill for math
Mitchell ClarkThe Verge
Illustration: Alex Castro / The Verge
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...Continue Reading