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 many milestones that are described in […]
Continue Readinggoogle sheets
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 visualize the connections […]
Continue ReadingGoogle 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 productivity apps, as this melds the two […]
Continue ReadingYou 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 another […]
Continue ReadingHow 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 DATEDIF(start_date, end_date, unit) […]
Continue ReadingGoogle 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 by in a formula. […]
Continue ReadingWorkspace: 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. However, some restrictions come with encrypted files — such as the ability to […]
Continue ReadingGoogle 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 Apps files opened directly and not necessarily through […]
Continue ReadingHow 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 can crunch some numbers. One […]
Continue ReadingGoogle 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 replace the current formula, […]
Continue ReadingGoogle 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 welcome change for corporations […]
Continue ReadingHow 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 instead, leaving the rest up to you. […]
Continue ReadingGoogle celebrates the adoption of Smart Canvas features, announces more to come
Building off of their announcement back in May of last year which introduced Smart Canvas – a new product experience that delivers the next evolution of collaboration for Google Workspace – Google posted today on The Keyword a summary of all the Smart Canvas features released to date. Additionally, Google boasted of the welcomed adoption […]
Continue Reading