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
Guides and How-To's
Of all the things we share with our readers, we get some of the most positive feedback concerning our guides and how-to articles. As many aren't fully familiar with the ins and outs of Chrome OS, these articles provide interesting and useful info for new and experienced users alike.
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)
How to remove yourself from Google Messages group MMS chats and stop all notifications
Recently, I've been added to several group chats that I did ask to be a part of but have since changed my mind on. Another chat I'm somehow in I most certainly did not ask to be included, yet I am anyway. Google Messages is a wonderful app, but it does have a lot of things it needs to work out. … [Read more...] about How to remove yourself from Google Messages group MMS chats and stop all notifications
How to tell Web apps and Android apps apart on your Chromebook
ChromeOS is one of the few operating systems that allows you to install applications from other operating systems, as is the case with Linux and Android apps that run in their own separate containers. However, having a combination of web app shortcuts, PWAs, Android apps, and Linux apps running on … [Read more...] about How to tell Web apps and Android apps apart on your Chromebook
How to install non-Google Play Store apps on your Chromebook without switching to developer mode
Sometimes, an Android app that you want to install on your Chromebook may simply not be available on the Google Play Store. This could be either because it's incompatible, or because the app's developer has tagged it as such due to the experience on your device not being exactly how they prefer to … [Read more...] about How to install non-Google Play Store apps on your Chromebook without switching to developer mode
10 fun and useful Google search Easter eggs you should try right now
Sometimes I simply forget how fun the hidden Easter eggs are in Google search result pages. My favorite memory of one of these happened with the release of Avengers: End Game and Thanos' gauntlet. To this day, I remember that interaction with Joe like it was yesterday. We all still worked for … [Read more...] about 10 fun and useful Google search Easter eggs you should try right now
How to switch clock styles on your Android phone’s lock screen
Android 12 introduced a double-line clock on the lock screen that turned out to be a bit controversial as some users preferred the simpler, one-line design of the old clock. This new larger clock style appeared on the lock screen if there were no notifications and would revert back to the old … [Read more...] about How to switch clock styles on your Android phone’s lock screen
How to use face detection on Pixel to improve auto-rotate
I'm sure you can relate to how annoying it is to lie down while using your phone and have your phone's display rotate to landscape orientation. This particular scenario was responsible for people turning off auto-rotate on their phones altogether and manually enabling it as needed. But what if I … [Read more...] about How to use face detection on Pixel to improve auto-rotate
How to disable duplicate notifications for apps and web apps on your Chromebook
The Chromebook notification tray has recently received a huge visual refresh, and quite honestly, it looks gorgeous. I had initially predicted it with my Material You for ChromeOS mockup, and now that it's here, it feels like just another part of the operating system. All in all, it along with the … [Read more...] about How to disable duplicate notifications for apps and web apps on your Chromebook
Use this hidden Gmail trick to sort and route email like a ninja
If you've ever signed up for a giveaway, registered for an event, entered your email to get a coupon, or been in any other situation where you needed to sacrifice your email address to get something you wanted, you know the immediate sadness you feel when you start getting all sorts of junk mail as … [Read more...] about Use this hidden Gmail trick to sort and route email like a ninja
How to set your Chromebook’s Calendar View widget to start on Mondays
Ever since Google introduced the Calendar View widget to ChromeOS in version 104, many discussions have been had about how to improve it. One of the most requested features for it, besides having the ability to integrate all of your Google Calendars, is how to change the starting day of the week to … [Read more...] about How to set your Chromebook’s Calendar View widget to start on Mondays
How to add gift cards to the new Google Wallet app
Google has prepared a blast from the past in the form of its efforts to revive the Google Wallet app and branding. The idea is to offer users a more card-centric, user-friendly experience that's not centered on peer-to-peer payments and transaction management like Google Pay. Wallet allows you to … [Read more...] about How to add gift cards to the new Google Wallet app
How to use the Google Photos’ Camouflage feature
Google debuted "Camouflage," a Google Photos companion feature to Magic Eraser which helps get rid of distracting objects by applying a muted color instead of completely erasing it, with the launch of the Pixel 6a. Luckily, the feature eventually made its way to the Pixel 6 and Pixel 6 Pro, … [Read more...] about How to use the Google Photos’ Camouflage feature












