Better Sheets on YouTube

Stop Formatting Cells. Format Inside the Formula Instead

Learn how to format numbers as currency within a formula in Google Sheets, ensuring your totals display correctly with dollar signs and appropriate formatting.

Automate Two Sheets

In this video, learn how to automate sorting across multiple sheets in Google Sheets using Apps Script. Discover various methods to set up triggers for daily automation of your sorting functions.

ROUND Tens, Hundreds, Thousands

Learn how to round numbers to the nearest tens, hundreds, or thousands in Google Sheets with this quick and effective tutorial. Discover practical applications for rounding in inventory management, budgeting, and property valuation.

Gemini in Apps Script

Gemini in Apps Script

Searchable Dropdown

Learn how to create a searchable dropdown list in Google Sheets to easily find and select items from large datasets, enhancing your productivity and efficiency.

Average Only Checked in Google Sheets

Learn how to calculate the average of only checked items in Google Sheets using checkboxes and the FILTER function. This tutorial also covers how to handle errors when no checkboxes are selected.

Add Zero in Front of Phone Number

Learn how to add a zero in front of phone numbers in Google Sheets without complicated formatting. This quick tip ensures your numbers display correctly while maintaining flexibility in input.

The Ultimate Weight Tracker Template

Discover the ultimate weight tracker template that combines powerful features to help you achieve your weight loss goals effortlessly. With automated reminders, goal setting, and integration with Google services, this template ensures you stay accountable and motivated.

Square Cell

In this video, learn how to create square cells in Google Sheets using Apps Script, making your dashboards visually appealing and easy to manage. Discover how to automate cell resizing with a custom menu for enhanced functionality.

Month in a Cell

Learn how to display the full month name in a cell using Google Sheets by formatting numbers and customizing date and time settings.

Roll Dice

Learn how to roll dice in Google Sheets using the RAND and CHOOSE functions to generate random numbers and even emojis. This video provides a fun way to incorporate randomness into your spreadsheets.

How to Filter By Color in Google Sheets

Learn how to filter data by color in Google Sheets with this step-by-step tutorial. Discover how to highlight specific entries and manage your filters effectively.

Does google sheets have dark mode

Learn how to enable dark mode in Google Sheets and enhance your experience with a simple trick using Chrome flags. This video also covers customizing your sheet's background and text colors for a better dark mode look.

OnlySheets.bettersheets.co

Discover Only Sheets, a unique tool designed to protect your Google Sheets from unauthorized access, turning a humorous concept into a practical solution.

Ask Me Questions #googlesheets

In this video, the creator discusses their passion for answering Google Sheets questions and introduces a new platform, answer.com, designed to facilitate this interaction. They emphasize the importance of context for beginners and the innovative use of AI in the question-answering process.

Open Excel File in Google Sheets

Learn how to easily open and convert Excel files into Google Sheets, unlocking all the powerful features of Google Sheets in the process.

Find Files in Folder by Name Apps Script

Learn how to find files in a specific Google Drive folder by name using Apps Script, ensuring you retrieve the correct file even when multiple files share the same name.

Dutch Auction in Google Sheets and Google Forms

Learn how to create a Dutch auction using Google Sheets and Google Forms, where item prices decrease over time until sold. This tutorial covers form creation, automation for price reduction, and tracking sold items.

Create Calendar Event When Form Submitted

Learn how to automatically create a Google Calendar event when a Google Form is submitted, scheduling a review session one week later using Google Apps Script.

Automate Emails by Google Form Responses Using Google Apps Script Email Certain Department Based on

Learn how to automate email notifications to different departments based on Google Form responses using Google Apps Script. This tutorial walks you through creating a database of emails, setting up a Google Form, and linking it with an Apps Script to send emails upon form submission.

How to Create a Tab For Every Week of the Year

Learn how to create a tab for every week of the year in Google Sheets using Apps Script. This tutorial walks you through the necessary code adjustments to customize your weekly tabs based on your preferred starting day.

this guy Google Sheets #googlesheets

In this video, the creator shares their unique perspective on Google Sheets, blending humor and insights to make the tool more enjoyable and accessible.

Why My Number Fonts Terrible?

Discover how to enhance the appearance of numbers in your spreadsheets by using monospace fonts for better clarity and distinction.

this guy Google sheets #spreadsheetmagic

In this video, the creator humorously showcases their love for Google Sheets while highlighting its powerful features, all fueled by coffee.

Brand New Sheet

Learn how to quickly create a new Google Sheet using the simple URL 'sheet.new'. This method works seamlessly across different accounts and even in incognito mode.

Highlight Footer

Learn how to highlight the footer row in Google Sheets and customize its appearance using formatting options like alternating colors.