Better Sheets

YT Expense Tracker Template with Data Entry Form Inside Sheets https://lnkd.in/eVzZqyKE Create a Simple Automated Expense Tracker in Google Sheets get this template free: https://lnkd.in/ea7PBpAx In this tutorial, learn how to create a simple and efficient expense tracker in Google Sheets. Follow along as we build a dashboard that allows you to enter expenses, costs, and dates through an easy-to-use form. We'll cover creating a summary sheet to view totals and subtotals for specific date ranges, as well as how to automate the process of adding new expenses with Google Apps Script. By the end of this video, you will have a functional and automated expense tracking system with a clean, user-friendly interface. 00:00 Introduction to the Expense Tracker 00:20 Setting Up the Dashboard 03:21 Creating the Expense Form 03:54 Automating Data Entry with App Script 07:33 Adding a Clickable Button 08:38 Final Touches and Summary

Create an Automated Extended Weekly Calendar View in Google Sheets https://lnkd.in/gg8hF6bN Create an Automated Monthly Calendar View in Google Sheets In this tutorial, learn how to transform a weekly calendar view into a monthly one in Google Sheets. This video explains step-by-step how to update dates dynamically, extend the view to encompass multiple weeks, and automatically adjust calendar events using customizable formulas. Perfect for those looking to automate and expand their calendar management. Stay tuned for more automation tips and tricks from Better Sheets on YouTube! 00:00 Introduction to Weekly Calendar View 00:22 Transitioning to a Monthly Calendar View 00:38 Setting Up the Monthly Calendar 00:50 Automating Date Updates 01:46 Expanding the Calendar 02:39 Conclusion and Next Steps

Automate Emails by Google Form Responses Using Google Apps Script Email Certain Department Based on https://lnkd.in/gTZR3btQ Automate Emails by Google Form Responses Using Google Apps Script In this video tutorial, we demonstrate how to automate sending emails to different departments based on responses from a Google Form. You'll learn how to create a department-specific email database, construct a Google Form for internal use, script an Apps Script that triggers emails to specified departments, and set up an onFormSubmit trigger for automation. Follow along for a step-by-step guide and a final working script, making this process efficient and easy to manage. 00:00 Introduction and Objectives 00:23 Creating the Google Form 00:45 Setting Up the Database 01:27 Designing the Form 02:42 Writing the Apps Script 06:16 Creating the Form Submit Trigger 06:51 Testing and Debugging 08:41 Conclusion and Recap

Make a Tour of the Sheet https://lnkd.in/eUPDZDpX Google Sheets App Script Tutorial: Create an Interactive Sheet Tour In this video, learn how to build a custom App Script to create an interactive tour for your Google Sheets. Perfect for users needing a guided experience through specific tabs, this tutorial covers the step-by-step process of scripting a tour, including sheet activation, generating alerts, hiding and unhiding sheets, and more. Follow along to enhance your Google Sheets experience with this unique and helpful tool! 00:00 Introduction to the Sheet Tour 00:35 Starting the Tour 00:52 Navigating Through Tabs 01:01 Unhiding Sheets 01:07 Building the App Script 01:15 Understanding the Script Functions 03:09 Final Steps and Conclusion

Create a Lead Magnet Spreadsheet (Template included) https://lnkd.in/gwRKtdAR Create Custom Exercise Spreadsheets Using Google Sheets and ChatGPT get the template: https://lnkd.in/ghfnMUkX In this video, I discuss a unique way to help busy family men keep fit by creating a spreadsheet of exercises they can do while engaging in other activities. Using ChatGPT for the initial exercise ideas, I show how to transform this information into a professional and engaging Google Sheet. From formatting headers to adding dynamic dropdowns and checkboxes, this tutorial guides you through creating a lead magnet that could attract potential clients for your personal training business. Follow along to see step-by-step how to customize and enhance the spreadsheet, making it both useful and visually appealing. 00:00 Introduction: Offering Spreadsheet Ideas 00:30 Creating Exercise Lists for Busy Family Men 01:07 Building a Lead Magnet with Chat GPT 01:29 Designing the Spreadsheet Layout 02:25 Adding Interactive Elements 05:48 Customizing Dropdown Menus 09:47 Branding and Final Touches 10:56 Sharing and Copying the Sheet 12:16 Conclusion and Next Steps

Create a Household Chores Board in Google Sheets https://lnkd.in/gM2hhUza Create a Visual Household Chore Board in Google Sheets Learn how to create a dynamic Kanban-style household chores board using Google Sheets. This tutorial walks you through the process of assigning chores, inserting checkboxes, and viewing tasks based on household members. See how you can easily manage and print your chore lists, ensuring everyone in the household has an equal share of work. Perfect for keeping your home organized and ensuring responsibilities are clearly distributed! 00:00 Introduction to Household Chores Board 00:13 Setting Up the Kanban Board 00:16 Filtering Tasks by Person 00:31 Copy-Pasting and Fixing Errors 00:54 Adding Checkboxes 01:08 Final Touches and Dynamic Updates 01:19 Conclusion and Subscription Prompt

How To Color Code Drop Down List for Whole Row in Google Sheets https://lnkd.in/dNjcfpBC How to Color Code a Drop Down List in Google Sheets Learn how to transform a drop-down list in Google Sheets by adding color coding for different statuses like 'completed,' 'in progress,' and 'overdue.' This tutorial covers selecting the appropriate cells, changing colors, and using data validation rules to fill cells with custom colors. Additionally, the video explains how to use conditional formatting to color code entire rows based on the values in a drop-down list. Subscribe to BetterSheets on YouTube for more advanced Google Sheets tutorials. 00:00 Introduction to Color Coding in Google Sheets 00:07 Creating a Drop Down List 00:34 Customizing Drop Down Colors 01:21 Advanced Color Customization 01:44 Conditional Formatting for Entire Rows 03:05 Final Touches and Subscription Prompt

How To Calculate Average Workout Time Per Weekday https://lnkd.in/gT7PEC8r Calculate Average Workout Time Per Weekday Using Google Sheets In this tutorial, we'll walk you through how to calculate your average workout time per weekday using Google Sheets. You'll learn how to use the 'AVERAGEIF' function to determine which day of the week you work out the most. Join us to enhance your Google Sheets skills and achieve a more organized and efficient workflow. Don't forget to subscribe to BetterSheets for more tips and tricks! 00:00 Introduction to Calculating Average Workout Time 00:03 Setting Up the Data 00:22 Using the AVERAGEIF Function 00:42 Analyzing the Results 00:52 Final Adjustments and Tips 01:04 Subscribe for More Google Sheets Tips

How to Create a Sequential ID when Google Form Submitted to Google Sheets https://lnkd.in/gFFVHgGv How to Create Sequential IDs in Google Sheets with Apps Script In this tutorial, you will learn how to generate sequential IDs in Google Sheets using Apps Script. We'll walk you through setting up a unique ID for each form response submission, and then show you how to switch to a sequential ID system. You'll learn two methods: one using a separate sheet to track IDs and another using the Properties Service to store and increment IDs. By the end of this video, you'll be able to customize the starting point of your sequential IDs and understand how to maintain them efficiently. Ideal for anyone looking to streamline data management in Google Sheets! 00:00 Introduction to Unique and Sequential IDs 00:11 Setting Up the Script for Sequential IDs 01:01 Creating a New Sheet for ID Management 01:31 Implementing Sequential ID Logic 02:04 Testing the Sequential ID Function 02:24 Using Property Service for ID Storage 03:53 Final Adjustments and Testing 05:06 Conclusion and Additional Tips

Conditional Formatting With Checkboxes in Google Sheets https://lnkd.in/g56cqReP Master Google Sheets: Advanced Conditional Formatting with Checkboxes Learn how to enhance your Google Sheets by using conditional formatting with checkboxes. This tutorial walks you through the steps of using custom formula rules to format text in a task column based on checkbox states. Discover how to apply strikethroughs, change text and background colors, and manage formatting across entire rows for better spreadsheet automation. Subscribe to BetterSheets on YouTube for more tips and tricks. 00:00 Introduction to Conditional Formatting with Checkboxes 00:17 Setting Up Conditional Formatting Rules 00:54 Customizing the Formatting Rules 01:13 Applying Formatting Across Entire Rows 01:27 Conclusion and Further Resources