New YouTube Videos and Code for Sheets Formulas with Apps Script

by

Google Sheets Formulas Capitalize the first letter of each word in a given string function CAPITALIZE_WORDS(str) {  const words = str.split(‘ ‘);  for(let i=0;i<words.length;i++){    words[i] = words[i].charAt(0).toUpperCase() + words[i].slice(1).toLowerCase();  }  return words.join(‘ ‘); } The given code defines a function called CAPITALIZE_WORDS that takes a string str as an argument. The purpose of the function … Read more

Count the number of occurrences of a given substring in a string

by

Count the number of occurrences of a given substring in a string function COUNT_SUBSTR(str,sbStr){  let count = 0;  let pos = str.indexOf(sbStr);  while (pos !== -1){    count++;    pos = str.indexOf(sbStr,pos+1);  }  return count; } The provided code defines a function called COUNT_SUBSTR that takes two parameters: str and sbStr. The purpose of this function is … Read more

Install NPM within node

by

To install npm (Node Package Manager) along with Node.js, you can follow these steps: If the above steps were successful, you now have Node.js and npm installed on your system. You can start using npm to manage your Node.js packages and dependencies. Note: If you’re using a Linux or macOS system, you may need to … Read more

Extracting Domain Name from URLs: A Tutorial

by

function GET_DOMAIN(url){  let domain = ”;  let matches = url.match(/^https?\:\/\/([^\/?#]+)(?:[\/?#]|$)/i);  if(matches && matches[1]){    domain = matches[1];  }  return domain; } The given code defines a function called GET_DOMAIN that extracts and returns the domain name from a given URL. The domain name represents the network location of a website. The function follows these steps: To … Read more

Convert Values to Roman Numerals in Google Sheets with Custom Formula

by

Convert a number to its Roman numeral equivalent function TO_ROMAN(num){  if(typeof num !== ‘number’) return NaN;  let roman = ”;  const romanValues = {    M: 1000,    CM: 900,    D: 500,    CD: 400,    C: 100,    XC: 90,    L: 50,    XL: 40,    X: 10,    IX: 9,    V: 5,    IV: 4,    I: 1  };  for(let key in romanValues){ … Read more

Google Sheets: Extract Last Characters from String

by

Return the last number of characters of a string function LAST_VALS(str,num){  if(num >= str.length){    return str;  }  return str.slice(str.length – num); } The provided code defines a function called LAST_VALS that takes two parameters: str and num. The function returns the last num characters from the str string. Here is a detailed explanation of how … Read more

Google Sheets Formulas Examples and source code

by

Google Sheets Formulas Capitalize the first letter of each word in a given string function CAPITALIZE_WORDS(str) {  const words = str.split(‘ ‘);  for(let i=0;i<words.length;i++){    words[i] = words[i].charAt(0).toUpperCase() + words[i].slice(1).toLowerCase();  }  return words.join(‘ ‘); } The given code defines a function called CAPITALIZE_WORDS that takes a string str as an argument. The purpose of the function … Read more

Getting started with Gmail

by

Introduction to Gmail What is Gmail? Gmail is a free email service provided by Google. It offers a variety of features that make it one of the most popular email services in the world, including: Why use Gmail? There are many reasons to use Gmail, including: Getting started with Gmail To get started with Gmail, … Read more

Top 10 Tips for using Google Apps Script

by

Here are the top 10 tips for using Google Apps Script: Remember, practice and experimentation are key to mastering Google Apps Script. Don’t be afraid to try new things and build upon your knowledge as you go along. Happy scripting!

YouTube Channel Top Tips

by

Remember, growing a YouTube channel takes time and effort. Be patient, adapt your strategies based on the feedback and data you receive, and continue to provide value to your audience.