Google is updating its Google Sheets spreadsheet app on the web today with a few new features and improvements. First up, the updated app now includes new customization options for charts including the ability to add data labels as well as shapes to denote data points including stars, triangles, and pentagons.
Some of the other new features arriving today include a preview for formula results in real-time when typing, the ability to filter rows and columns by “greater than” and “text contains”, and an option to add calculated fields “to pivot tables when you want to apply formulas to pivot table data.”
Google adds that you’ll also now be able to “Use the GETPIVOTDATA function to more easily retrieve data from your pivot table.”
Lastly, Google has a new option to present a customized warning message to collaborators that attempt to edit something they shouldn’t (pictured below):
You can check out the updated Google Sheets web app now.