DOWNLOAD TEMPLATE This is the formula that I use: To calculate the percentage: =IFERROR(COUNTIF(B6:B15,TRUE)/COUNTA(C6:C15),0) To insert a progress ring into the planner: =IFERROR(INDEX(‘Set Up’!C2:C22, MATCH(B16, {0%, 5%, 10%, 15%, 20%, 25%, 30%, 35%, 40%, 45%, 50%, 55%, 60%, 65%, 70%,…
Thank you for choosing our money tracking template! This guide will help you set up and utilize the template effectively. Follow these steps to get started: 🌟 Getting Started: Make a Copy When you first receive the spreadsheet, especially on…
Thank you for choosing our money tracking template! This guide will help you set up and utilize the template effectively. Follow these steps to get started: 🌟 Getting Started: Make a Copy When you first receive the spreadsheet, especially on…
DOWNLOAD TEMPLATE Today, I’ll guide you step-by-step on how to create a dynamic calendar in level 2 Google Sheets. With this calendar, you can select the start day of the week, and today’s date will be automatically highlighted. I’ve also…
DOWNLOAD Are you looking for a simple yet effective way to create a dynamic calendar in Google Sheets? Whether you’re organizing your personal schedule or managing a team, this quick guide will show you how to build a fully functional…
DOWNLOAD Are you looking for an easy way to track your emotions daily? A mood tracker can help you gain insights into your emotional patterns and take control of your mental health. The best part? You can create your very…
DOWNLOAD TEMPLATE Managing your finances effectively starts with staying organized. A bills calendar in Google Sheets can help you track due dates, amounts, and payment statuses in one place. In this guide, I’ll show you how to create a customized…
DOWNLOAD Tracking your sleep is essential for maintaining a healthy lifestyle. If we’re going to spend about a third of our lives sleeping, why not track it in a fun and efficient way? In this tutorial, I’ll show you how…
DOWNLOAD Organizing your hashtags and keywords is essential for managing your content on platforms like Instagram, YouTube, and more. Today, I’ll guide you step-by-step to create a powerful and easy-to-use Hashtag and Keyword Manager in Google Sheets. This tool will…
DOWNLOAD Hi everyone! Welcome back to Notedii, your go-to space for all things creative and productive with Google Sheets! Last time, we explored how to create mood and habit trackers, but today, we’re diving into something super practical: an attendance…