Spreadsheet

Best Google Spreadsheet (Sheets) formula examples: Query, Match, Lookup, Lambda, Database Functions, etc.

Dynamic Hourly Time Slot Booking Template in Google Sheets

Hourly Time Slot Booking Template in Google Sheets

2
In this post, we will provide an hourly time slot booking template in Google Sheets along with the formulas used to create it. Here's how...
Cumulative Sum with Multiple Subcategories in Google Sheets

Running Total with Multiple Subcategories in Google Sheets

0
In this tutorial, we'll explore the simplicity of running totals with multiple subcategories in Google Sheets. We'll create an array formula to consistently update and...
Newlines Within Cells in Google Sheets for Sorting

Sorting Data Separated by Line Breaks within Google Sheets Cells

0
We can utilize a Lambda function to sort data separated by line breaks within cells in either ascending or descending order in Google Sheets. This...

Reset Running Total at Blank Rows in Google Sheets

0
In this guide, we'll explore the step-by-step process to reset the running total at blank rows in Google Sheets. Assume you have a dataset where...

Finding the First Sunday, Monday, etc., Date in a Month with Google Sheets

1
Learn how to efficiently find the first occurrence of specific weekdays, such as Sunday, Monday, and more, in any given month using Google Sheets. Sometimes,...
HYPERLINK formula with Calendar Dates in Google Sheets

Hyperlink Calendar Dates to Events in Google Sheets

0
In this blog post, we will show you how to use the HYPERLINK function to link calendar dates to events in Google Sheets. This...