Google continues on improving its "Smart Canvas" product experience which aims to deliver the next evolution of collaboration for Google Workspace. In this latest update, Google is adding dropdown chips in Google Sheets giving you the ability to easily show the progress of a project or one of the … [Read more...] about Google Sheets get a new project tracking Smart Canvas feature
google sheets
Support our independent tech coverage. Chrome Unboxed is written by real people, for real people—not search algorithms. Join Chrome Unboxed Plus for just $2 a month to get an ad-free experience, access to our private Discord, and more. Learn more about membership here.
START FREE TRIAL (MONTHLY)START FREE TRIAL (ANNUAL)
Google Sheets improves creating and modifying Pivot Tables
A pivot table is a very popular type of statistical tool that may be used to produce reports that summarize and reorganize chosen columns and rows of data contained within a database or spreadsheet. The spreadsheet or database structure is not altered in any way by the tool but rather helps you … [Read more...] about Google Sheets improves creating and modifying Pivot Tables
Google adds timeline view to Sheets as part of Smart Canvas
Google introduced Smart Canvas last year as a reimagined approach to working with others in Workspace and has been steadily adding features to apps under the Workspace umbrella. Yesterday Google added one more feature in Smart Canvas that will be very welcomed by fans of Google Sheets and … [Read more...] about Google adds timeline view to Sheets as part of Smart Canvas
You can now add files and events to Google Sheets using Smart Chips
With the exciting launch of the Pixel 7 series last week, you'd be forgiven not to know that there was a whole other Google event taking place. The event was Google Cloud Next '22, which is considered Google's flagship event of the year and where people interested in the cloud can learn from one … [Read more...] about You can now add files and events to Google Sheets using Smart Chips
How to Create a Countdown Timer in Google Sheets
Today we are going to learn how to create a countdown timer in Sheets by using a couple of built-in functions. These are going to be DATEDIF, which calculates the number of days, months, or years between two dates, and NOW() which return today's date. The syntax for the DATEDIF formula is … [Read more...] about How to Create a Countdown Timer in Google Sheets
Google Sheets introduces Named Functions that can be reused in other Sheets
The Google Workspace blog announced a new Sheets feature that allows you to create custom functions that can be reused across files. The functionality, called "Named Functions," is similar to Named Ranges in which you can select a specific range of cells and give them a unique name to reference them … [Read more...] about Google Sheets introduces Named Functions that can be reused in other Sheets
Workspace: You will soon be able to copy encrypted documents, spreadsheets, or presentations
Google Workspace admins and organizations have the option to enable client-side encryption for files in their domain. This encryption encodes and provides another layer of security beyond the standard AES 256-bit encryption that Google Drive provides to files that are considered confidential. … [Read more...] about Workspace: You will soon be able to copy encrypted documents, spreadsheets, or presentations
Google Apps will now warn you when opening a potentially dangerous file
In January, Google rolled out warning banners for potentially malicious or dangerous files in Google Drive. This came about as a necessity after several scams surfaced that used Google Docs or Google Sheets files to spread abusive content. Google is now extending that same functionality to Google … [Read more...] about Google Apps will now warn you when opening a potentially dangerous file
How to sort data by date in Google Sheets
Google Sheets may be one of the most undervalued tools in the Google Workspace arsenal of productivity apps. Accounting fiends swear by more powerful applications such as Microsoft Excel, but there is a lot that Google Sheets can do that will suffice for those simply looking for an application that … [Read more...] about How to sort data by date in Google Sheets
Google Sheets can now suggest corrections for your formulas
Google Sheets is now adding the ability to suggest context-aware corrections to your formulas. The feature works similar to the formula suggestions added last year. It analyzes the data, and if it detects that an improvement can be made, it will offer a suggestion box with a new version that can … [Read more...] about Google Sheets can now suggest corrections for your formulas
Google doubles the cell limit in Google Sheets for Workspace accounts
Google announced today via the Workspace Updates Blog that the cell limit on Google Sheets has been increased from up to five million cells to up to ten million cells, effectively doubling its capacity. The new limit will apply to new, existing, and imported files. I imagine this will be a … [Read more...] about Google doubles the cell limit in Google Sheets for Workspace accounts
How to find and highlight duplicates in Google Sheets
Google Sheets includes an option to find and remove duplicates, but it doesn't give you a chance to review these duplicates before deciding whether they should be removed or not. Thankfully there is a workaround for this using conditional formatting and a handy formula that highlights the duplicates … [Read more...] about How to find and highlight duplicates in Google Sheets
