Google has unveiled several handy new features for Sheets, their Excel competitor that quite honestly needs all the help it can get. The goodies include enhancements to core functions in addition to collaboration. One of these involves being able to apply sharing permissions to specific parts of the spreadsheet, rather than the entire file.
With the new functionality, I can highlight a cell or set of cells and then right click, tap on "protect cells," and then alter the access rights to them. You may share your document with someone but not necessarily expect them to make major alterations. For instance, you might want several individuals to add some data to your spreadsheet but the formulae should stay consistent.
If your collaborator might have good reason to edit it or you are just afraid you might accidentally make a change, you can tell Sheets to flash a warning. On the Android app, the warning will look like this:
Alternately, you can totally prevent changes to that area. You can restrict it to yourself or any subset of the people you have collaborated with, which is a nice level of configurability.
Those who can view but not edit will just see "VIEW ONLY" where the formula/data normally displays when they highlight the affected cells.
Among the other new stuff is some added ability to edit charts. You can add data values, which shows the exact number for each point or bucket on your graph. Below is an example of how this looks on a line graph of mine, showing my MacBook Air's time-adjusted battery life over the course of a few weeks.
Also, you can change and remove the way the individual points are represented on the chart. Both shape and size are options. In this case, I chose filled-in circles and made them 7 pixels in diameter, but many others exist.
Unfortunately, the data values are not supported on the most recent Android app just yet. Here's how it looks after I changed the circles into stars:
The Android app just can't do much with charts, unfortunately.
Today's update to Sheets allows you to view data labels.
After we published, Google pushed an update to Sheets, version number 22.214.171.124.35 (up from 126.96.36.199.35). The main change relevant to these new features is that it can now view data labels that you add in the desktop version. See below for an example:
If you don't want to wait for the newest Sheets to reach you via the Play Store, head to APK Mirror and download it yourself.
Another noteworthy change is a live preview while you type out a formula. That is, it will calculate on the fly as you write your formula to help you see if you have made a mistake. This is how it looks on the desktop:
And again, no Android support just yet. Here are the rest of today's additions, per Google, each of which can't be enjoyed from Android.
- Filter rows and columns by conditions, including “greater than” and “text contains.” This way you’ll only see the numbers, dates and text you need.
- Add calculated fields to pivot tables when you want to apply formulas to pivot table data.
- Use the GETPIVOTDATA function to more easily retrieve data from your pivot table.
- Google Docs Blog