Tips And Tricks
Tips And Tricks
Everyday - Google Workspace
NEWEST UPDATE
Add an automatic countdown timer!
Tip: Are you creating a project tracker in Sheets? Maybe a timeline? Do you want people to see how much time is left until the big launch day, without having to constantly update it?
Add an automatic countdown timer!
How to use: In Sheets enter your "launch" or final deadline date in a cell. In your countdown cell enter =INT(A2-NOW()) where A2 is your final date.* Then go to File > Settings > Calculation > and drop down to On change and every minute. Now your date will stay updated all the time for anyone who opens the Sheet!
Tip: Do you have a bit of a tab problem and have a million things open at once? Do you find yourself opening the same Doc over and over? Wish there was a way to see if you already have something open in Chrome, and then switch over to it?
There is! Switch Tabs in Chrome!
How to use: Open a new Chrome tab, and start typing the name of a Doc or site you suspect you may already have open. If the tab is open, you'll see the item listed with the "Switch Tab" button next to it. Even if it's in another window it will bring you right to that tab and close the new tab you just opened. Less tabs, more efficiency!