Skip to main content

Google Sheets web app updated with new features, filters, and more

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.

FTC: We use income earning auto affiliate links. More.

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel

Comments

Author

Avatar for Jordan Kahn Jordan Kahn

Jordan writes about all things Apple as Senior Editor of 9to5Mac, & contributes to 9to5Google, 9to5Toys, & Electrek.co. He also co-authors 9to5Mac’s weekly Logic Pros series and makes music as one half of Toronto-based Makamachine.