Tag: Gsd Tips

Google Sheets: Consolidating Data from Multiple Tabs with SUMIF

By

Get Shift Done: Tips and Tricks

The tabs feature in Google Sheets is a great organizational tool, and it keeps thing neat and tidy. However, sometimes we need a summary spreadsheet, an at-a-glance overview of the data. Or perhaps it’s useful to see a single chart that updates as we add new information. In either case, the quickest solution is to use the =SUMIF function, and it’s easier than it initially appears.

As an example, let’s create a summarized list of the trucking suppliers we pay. First, add a new tab to the Google Sheet that records the column headers that match the information to summarize.


Read More

This Shortcut Lets You Add a Trello Card and a Description in One Step, Not Two

By

Get Shift Done: Tips and Tricks

The thought of re-typing all of your meeting notes into Trello can be a bit daunting. And no wonder — it not only takes time aways from other tasks, it’s boring!

Well, good news — there’s a shortcut for copying and pasting the to-dos from your meeting notes into Trello while adding a new card with a description, all in one step.

First, open up the Trello board you want to add cards to.

Read More

This Hack’s the Reason Google Keyword Planner’s Not Dead Yet

By

Get Shift Done: Tips and Tricks

Psssst…I’m gonna’ share a secret with you, but whatever you do, don’t tell Google.

You see, back in August, the company made a big change to their Keyword Planner, the free go-to tool for SEO specialists everywhere — instead of showing an exact number of “Average Monthly Searches,” it now shows a range — a really broad range:


Read More

This Voice Typing Tool in Google Docs Can Save You a Shiftload of Time and Money

By

Get Shift Done: Tips and Tricks

Do you record your thoughts in voice notes and then have someone transcribe them? Or, do you want to use voice recognition software, but find it too pricey? You can cut the time and money it takes to transcribe your words by using Google Docs’ voice typing tool.

To start, go up to the main menu of your document. Click on Tools.


Read More

How to Productively Stalk your Co-Workers using Dropbox Paper

By

Get Shift Done: Tips and Tricks

Photo by Bernard Goldbach

Did you know that you can use Dropbox Paper to ‘productively stalk’ your colleagues? This goes way beyond the simple ‘read receipts’ in email that you might be used to seeing in your inbox.

Instead of attaching a document to an email, you just use Dropbox Paper to send a link to it instead. You can give people edit-level or comment-level permissions and you can also control whether to share your document with:

  • specific people
  • everyone at your organization (if your org is setup on Dropbox), or
  • anyone who has the link
Read More

Use Your Google Apps Account to Get Free Phone Service for Your Business

By

Get Shift Done: Tips and Tricks


Guess what? With your Google Apps account you can get a phone number for your business that rings on your cell phone, transcribe your voicemails, and then sends those transcriptions to your Gmail inbox.

You can even send free text messages and make cheap international calls. Here’s how:

Read More

It’s Not Me, It’s You — Getting the 411 on Website Outages

By

Get Shift Done: Tips and Tricks

Source: http://downdetector.com/status/level3/map/

Given the open architecture and multitude of players involved in connecting you with a website, it’s a major technological achievement that the web works as often, and as well, as it does.

Except for when it doesn’t.

Read More

This One Simple Trick Will Get Your Writing Published!

By

But only if you turn on your email notifications….

I edit a publication on Medium, which means I spend an inordinate amount of time reading Medium. Which is pretty cool. What’s even cooler is finding an amazing story that fits NewCo Shift’s editorial voice and POV, then reaching out through Medium’s elegant platform to ask the author if we can run it in our publication. The author gets to reach a growing audience, Shift gets great writing, the audience gets a great read — Win Win Win!

But roughly 15–20% of the time I reach out to a new author, I get this:


Read More