Even though it is fantastic at calculating mathematical formulas, it doesn’t do so perfectly with textual content, but which is a little something Google is addressing in a new update to Sheets wherever they are introducing what they are calling “Smart Fill”. As TechCrunch points out, you could think of this as getting related to Gmail’s “Smart Compose” function wherever Sheets can suggest you formulas to use and will also be smarter at filling out textual content fields.
According to Google, “Say you have a column of entire names, but you want to break up it into two columns (first and last name, for case in point). As you start typing first names into a column, Sheets will routinely detect the pattern, crank out the corresponding method, and then autocomplete the relaxation of the column for you.”
In addition to Clever Fill, Google has also launched a Clever Cleanup software that enables users to clean up up info in their spreadsheets by hunting for duplicate rows and other formatting challenges. These are merely suggestions and users are totally free to disregard them if they experience like it’s not important.
Submitted in. Browse a lot more about Google. Resource: techcrunch