lswcap
Google announced the addition of two new features to Google Sheets, a spreadsheet application available in a web browser.
One is Smart Fill, which is a spreadsheet version of the Gmail Smart Compose function. It allows you to autocomplete the text you are typing. For example, if there is a name, work, and address in the worksheet, if you start explaining by selecting only the last name in the adjacent column, it is automatically detected as a data pattern, and the corresponding formula is automatically filled in the rest of the line.
For those who need to perform complex calculations in a spreadsheet that analyzes the information entered in the cell and automatically generates it, the heavy workload will be alleviated. In addition, the proposed formula can be used as it is, and can be adjusted if necessary. If you use the completion formula, you can naturally learn how to write a formula or a function.
Another added feature, on the other hand, is Smart Cleanup, which detects duplicate rows or format issues and suggests fixes. It is easy to detect errors that are difficult to notice with only a visual inspection in order to detect parts that are processing different from others and display the side panel with statistical information in an easy-to-understand manner.
These two features are expected to be available for the G Suite within 2020. Related information can be found here .
Add comment