Functions

Google Sheets Pivot Table: Sort by Value (3 Easy Ways)

The pivot table is perhaps the most powerful data summarization tool in Google Sheets. However, we can organize it further by sorting the data by the ...

Google Sheets: Create a Pivot Table with Data from Multiple Sheets

A pivot table is a powerful data summarization tool for any spreadsheet. Since it’s a spreadsheet, it is not uncommon to have data coming from ...

Group Dates in a Google Sheets Pivot Table (An Easy Guide)

Dates can often be all over the place making it quite tough to summarize their corresponding values, even with pivot tables. However, to help with ...

How to Apply and Work with a Calculated Field of a Google Sheets Pivot Table

In this simple tutorial, we will look at how we can apply and utilize a Calculated Field in a Pivot Table of Google Sheets. Let’s get started. ...

How to Filter with Custom Formula in a Pivot Table of Google Sheets

Pivot tables are perhaps one of the best data presentation tools available in any spreadsheet application. Which brings us to today’s question: Can ...

How to Insert a Timestamp in Google Sheets (An Easy Guide)

In this tutorial, we will look at how we can insert a timestamp in Google Sheets. There are multiple approaches we can take, taking into ...

How to Apply a Date Picker in Google Sheets (An Easy Guide)

Spreadsheet applications like Google Sheets rely heavily on dates having the correct format since wrong dates entered can have huge implications ...

How to Use the DATE function in Google Sheets (An Easy Guide)

In this simple tutorial, we take a deep dive into the DATE function of Google Sheets. We will discuss its importance and see a few of its uses as ...

How to Format Date with Formula in Google Sheets (3 Easy Ways)

Date formats in Google Sheets usually depend on the regional or locale settings. Most commonly mm/dd/yyyy for the United States and dd/mm/yyyy for ...

Generate Automatic Date in Google Sheets (3 Easy Ways)

In this tutorial, we will show you how to insert or generate an automatic date in Google Sheets. While the task itself is quite simple, it is the ...

Apply an Automatic Timestamp Using Google Sheets Script (3 Easy ways)

In this tutorial, we will look at how we can apply an automatic timestamp in Google Sheets using Apps Script. But first, let’s start with the basics. ...

How to Autofill Date in Google Sheets (A Comprehensive Guide)

This article looks to serve as a comprehensive guide discussing all the ways we can use to autofill a date in Google Sheets, starting from simple ...

Autofill Date when a Cell is Updated in Google Sheets (3 Easy Ways)

This is a simple guide to show you a few ways you can use to autofill a date when a cell is updated in Google Sheets. While there are functions and ...

How to Sum a Duration of Time in Google Sheets (An Easy Guide)

In this article, we will discuss how to sum the duration of time in Google Sheets. At first glance, the idea may seem simple, but a certain level of ...

How to Autofill or Continue Dates in Google Sheets (An Easy Guide)

One of the best features that Google Sheets has to offer is its autofill feature. It is smart enough to understand what type of data the user needs ...

OfficeWheel
Logo