Formulas Archives - Page 18 of 25

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

July 18, 2022 Basics

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 Apply and Work with a Calculated Field of a Google Sheets Pivot Table

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

June 20, 2022 Basics

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 Filter with Custom Formula in a Pivot Table of Google Sheets

How to Sort a Pivot Table in Google Sheets (An Easy Guide)

July 18, 2022 Basics

Many ask the question: Can you sort data in a Pivot Table in Google Sheets? The answer is a resounding yes. While simple, there is ...

How to Sort a Pivot Table in Google Sheets (An Easy Guide)

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

June 14, 2022 Basics

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 Insert a Timestamp in Google Sheets (An Easy Guide)

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

June 13, 2022 Basics

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

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

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

June 12, 2022 Basics

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 Use the DATE function in Google Sheets (An Easy Guide)

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

March 29, 2023 Basics

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 ...

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

Generate Automatic Date in Google Sheets (3 Easy Ways)

June 8, 2022 Basics

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 ...

Generate Automatic Date in Google Sheets (3 Easy Ways)

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

July 19, 2022 Basics

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 ...

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

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

June 2, 2022 Basics

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 Sum a Duration of Time in Google Sheets (An Easy Guide)

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

June 1, 2022 Basics

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 ...

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

How to Use the EOMONTH Function in Google Sheets (An Easy Guide)

May 31, 2022 Basics

If you want to generate the last day of a month which falls before or after a specified number of months, then the EOMONTH function of Google Sheets ...