Data, displayed rightToday’s launch also includes new tools for analyzing spreadsheet data. For example, people can:
- Preview the results of a formula, including any formula errors, instantly as they type.
- Filter rows and columns by conditions, including “less than,” “greater than,” “text contains,” “date after,” and more.
- Add calculated fields to pivot tables in order to apply formulas to pivot table data.
- Use the GETPIVOTDATA function to retrieve data from a pivot table.
Collaborate, confidentlyCollaborating in Sheets can greatly improve the end product, but it’s important to avoid making accidental edits. Currently, people can restrict who can edit an entire worksheet or range of cells using the
protected sheets and ranges feature. To reduce the number of unintended changes (e.g. typos) made by people who
do have permission to edit, today’s launch includes the ability to warn individuals who attempt to edit certain cells. This will facilitate increased collaboration, as owners won’t need to set complicated permissions in order to allow others to work on the document.
Try these updated Google Sheets features on the web today, and start telling better stories with data.