Google Sheets Formulas

How I Track Internship Applications in a Google Sheet

A guest post by Amney Mounir: one Google Sheet for summer internship applications, with deadline alerts, follow-up dates, and a simple status dashboard. Free template included.

How I Track Interview Prep in a Google Sheet

A guest post by Amney Mounir: one Google Sheet with a story bank, a practice log with spaced repetition, an application tracker and a dashboard, all on formulas you can read in a minute. Free template included.

One Sheet, Two Counts: A Root-Domain Check in Google Sheets

A list of websites can give you two numbers at once, and neither is the number of sites on it. Pull the root domain out of each URL, count unique roots next to the row count, and match two lists on the root. A guest post by Ivan Trefilov.

How To Make That Viral Growing Plant Progress Chart

Imagine checking off tasks and seeing a cute little plant sprout right before your eyes. That's exactly what we're going to create today!

Word Tracker and Progress Tracker in Google Sheets

Ever dreamed of having a personal writing assistant right there in your Google Sheets? Imagine tracking your word count, setting goals, and watching your progress grow – all without leaving your favourite spreadsheet app. Well, your dream is about to come true! In this post, we're going to show you how to create your very own word counter and goal tracker using Google Sheets. It's super easy to set up, completely customizable, and perfect for keeping you motivated on your writing journey. L...

5 Ways to Combine Names in Google Sheets

Ever found yourself stuck in a loop of copying and pasting names in Google Sheets? Let's face it, it's a task that can feel like a never-ending chore. But fear not, because I've got your back! So, we're diving into the world of Google Sheets and exploring five super-easy ways to combine first and last names into a single cell. No more manual labor, no more headaches. Imagine being able to whip up a list of full names in seconds, instead of spending hours on it. Sounds like a dream, right? We...

Discover Misspelled Duplicates

The built-in feature can sometimes miss duplicates that have subtle differences, such as variations in spacing or formatting. Our formula-based approach, on the other hand, provides a more granular level of control

Name Match: Who's In and Who's Out

Let's say you have a master list with over 700 names and a new list from a recent meeting containing 175 names. How will you identify which names from the new list aren't on the master list so they can be added.

9 Google Sheet Tips for Affiliate Marketers

Learn how to apply formulas and calculations within Google Sheets in order to develop a tracking system for the effectiveness of your campaigns.

Beginners Guide to Using Index, Row, and Column | Simply useful Google Sheets Formulas

You may be using Google Sheet to do math and find that you need to iterate a number. ROW() gets you the row you're on, and helps you with this.

How To Hide Data with Checkboxes in Google Sheets

Checkboxes in Google Sheets are a game-changer. They add interactivity, flexibility, and functionality to your spreadsheets, making data management easier and more enjoyable.

Simplifying Interest Gain Calculations with the EFFECT() Formula

This highlights how essential it is to have a dynamic and scalable tool that can adapt to real-world variables, such as changing interest rates and investment periods