Category: Google Suite

GWAOw! 6 – Sign PDF with Jotform Sign

In this episode of GWAOw!!! we look at Sign PDF with Jotform Sign.

About Sign PDF with Jotform Sign

Sign PDF with Jotform Sign is a Google Workspace Add On (GWAO) that allows you to collect e-signatures for any PDFs stored in your Google Drive.

This is such a useful tool that I have moved to Sign PDF with Jotform Sign for e-signatures of my client service agreements.

The add-on has some great tools that allow you to create and edit the input fields for your document before sending it to signatories.

Continue reading “GWAOw! 6 – Sign PDF with Jotform Sign”

Google Sheets FILTER function: Dates and Times

If you have landed on this page you may have discovered that dates and times don’t always work as you might expect with the Google Sheets FILTER  function.

In this tutorial, we are going to cover how to use FILTER on dates, times and date and time stamps (DTS).

You can follow through the tutorial in its entirety or use the table of contents below to get directly to what you need.

Continue reading “Google Sheets FILTER function: Dates and Times”

How do I reverse a range by Rows or Columns in Google Sheets

Google Sheets: SORT, INDEX, ROWS

Reverse Rows in Column in Google Sheets
My favourite Killjoy members. Column A – From most favourite. Column B Saving the best for last.

Sometimes you have a need to reverse a list quickly in Google Sheets.

That’s pretty easy to do if the list is sorted alphabetically. Just go on into the <Data> menu and choose from one of the sort functions. But what if the data you want to flip is not in alphabetical or numeric order?

Below are 3 ways to reverse your data:

Also check out the last example on how to flip a column in Google Sheets.

For the examples below, I’ll be using a list of my favourite Killjoys characters. Yeah, I’m a sci-fi geek.

Continue reading “How do I reverse a range by Rows or Columns in Google Sheets”

Add the Current Date to a Sheet When Data Is Added So That The Date Does Not Change(Static) – Google Sheets (Updated July 2023)

Google Sheets, Google Apps Script: onEdit

You’ve probably come across the problem where you need to know when a piece of data has been added to your spreadsheet. You probably have been equally frustrated that there is no out-of-the-box function that will do just this.

You’ve tried TODAY() and NOW(), but they change dynamically. What you really need here is something that does not change.

Let’s look at two workarounds that can help you out with this problem.

Continue reading “Add the Current Date to a Sheet When Data Is Added So That The Date Does Not Change(Static) – Google Sheets (Updated July 2023)”