The Economic Times
English EditionEnglish Editionहिन्दीગુજરાતી
| E-Paper
Search
+

    Google Sheets introduces new features, Smart Fill and Smart Cleanup, to make calculations, formatting simple

    Synopsis

    Smart Fill borrows from Google’s Smart Compose feature.

    Agencies
    Smart Cleanup, is programmed to detect duplicate rows and other formatting issues.
    Spreadsheet software like Google Sheets and Microsoft Excel are powerful tools in the hands of tech geeks or those with considerable experience in running macros to perform complex calculation. However, for lay users, learning how to code using such programs can be quite arduous. To address this divide, Google will add two new features – Smart Fill and Smart Cleanup - that will save amateurs a lot of time while working with Sheets, as per a report by TechCrunch.

    Smart Fill borrows from Google’s Smart Compose feature that is used extensively in Gmail and Docs. When Google Sheets detects a pattern in user behaviour, it will attempt to fill the rest of the document based to past input. The Smart Fill feature achieves this by creating a formula in lieu of the user inputting data in the cells.

    This gives users control over how formulas work. It also empowers them to tweak suggestions when Smart Fill throws up unintended results. New users unfamiliar with how formulas and macros work can refer to Smart Fill to learn how to operate manually. The second feature, Smart Cleanup, is programmed to detect duplicate rows and other formatting issues. It scans spreadsheets for formatting snags and suggests fixes using artificial intelligence.

    Google has previously used AI to make Sheets more user friendly for casual users. It added natural language recognition to the app’s “Explore” tool in 2017. Smart Fill and Smart Cleanup will be added to the update Sheets app later this year.
    The Economic Times