Google Apps Script that processes each row in a Google Sheet checking the last part of a string in a specific column

To create a Google Apps Script that processes each row in a Google Sheet, checking the last part of a string in a specific column, and if that last part is all numeric, splits it off and copies it to the next column, follow these steps. This script assumes you want to check and process … Read more

Apps Script that removes blank rows in a Google Sheet

To create an Apps Script that removes blank rows in a Google Sheet, you can follow the steps below. This script will scan through the sheet for any rows that are entirely blank and remove them. Here’s a simple script to do that: That’s it! Now you have a script that can remove all blank … Read more

Google Apps Script cells string value separates it by the first comma then pastes the remaining part of the string into the following column

To create a Google Apps Script for Google Sheets that processes a range of cells by taking each cell’s string value, separates it by the first comma found in the string, and then pastes the remaining part of the string into the following column, follow these steps. This script will iterate over a specified range, … Read more

Google Apps Script that takes the value of a cell and separates the last two items by a space moving them to new columns

To create a Google Apps Script that takes the value of a cell in Google Sheets, and separates the last two items in the string by a space, moving them to new columns in the same row, follow these steps. This script will loop through a specified range in your sheet, split the content of … Read more

Mastering Google Sheets Automation with Google Apps Script Unveiling SpreadsheetApp Secrets

Apps Script SpreadsheetApp 🚀 Mastering Google Sheets Automation with Google Apps Script: Unveiling SpreadsheetApp Secrets! 🚀 Introduction to SpreadsheetApp I’m excited to share some deep dive insights into Google Apps Script, especially the incredibly powerful SpreadsheetApp class. If you’re passionate about automating and revolutionizing your Google Sheets experience, these tips are tailor-made for you! 📊💻 … Read more

🚀 New Tutorial Alert! 📊 | Master Google Sheets: Sorting Data Made Easy 🌟

Are you tired of messy data in your Google Sheets? Struggling with unorganized lists that need sorting into neat columns? We’ve got you covered! In our latest tutorial, we dive deep into the magical world of Google Sheets and its powerful ‘Split Text to Columns’ feature. 📈✨ 🎥 In this video, you’ll learn: Whether you’re … Read more

Mastering Google Apps Script: SpreadsheetApp Class

Google Apps Script SpreadSheetsApp class Google Apps Script – sheetsapp Class The spreadsheetsapp class is specifically designed to work with Google Sheets. It offers a range of methods that allow developers to perform operations such as reading and writing data, formatting cells, creating charts, and more. Basic Example: // Open the active spreadsheet var spreadsheet … Read more

Future value of an investment using compound interest Google Apps Script Custom Formula

🚀 Unlock the Power of Compound Interest: Calculate Your Future Investment Value with Custom Formulas! Ever wondered how your investments will grow over time with compound interest? In this tutorial, we’ll show you how to create a custom formula using Google Sheets to calculate the future value of an investment based on key factors like … Read more

Create Apps Script custom functions How to get the total amount of items including the tax rate

How to get the total amount of items including the tax rate  CALC_TOTAL_AMOUNT Product Price Quantity Tax Rate Subtotal Total Amount Product A 10 5 0.08 4 54 Product B 20 3 0.05 3 63 Product C 15 2 0.1 3 33 Total 150 In this example, we’ll create a custom formula that calculates the … Read more

Google Sheets get Data from two sheets to use within a custom function

How to use data from two sheets to create a custom Apps Script function  CALC_TOTAL_COST_WITH_TAX function getTaxRate(category) { const sheets = SpreadsheetApp.getActive().getSheetByName(‘TaxTable’); const taxTable = sheets.getDataRange().getValues(); let tax = 0 taxTable.forEach(val =>{ if (val[0] == category) { tax = val[1]; } }) return tax; } function test(){ Logger.log(getTaxRate(‘Category 1’)) } Category Tax Rate Category 1 … Read more