Have you ever woken up in the middle of the night thinking – phawh! I’d really like to know how many words there are in a paragraph – Or stopped mid-chew on some arbitrary item carelessly left in the paddock by the boss and thought – geez! If there was only a way to count the number of sentences in a paragraph in a cell in Google Sheets!?
In this short tutorial, Yagisanatode will show you how to get the total count of words in a cell and the total count of sentences in a cell in Google Sheets. They even have a how-to on getting the average sentence length in a paragraph.
Source: Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode
Have you ever wanted to delete or add columns in a Google Sheet, based on another set of Sheet data?
In this tutorial, we’ll show you how to use Google Apps Script to update your headers based on another sheets values. These sheets values can come from the current Google Sheet workbook or another one. We will also ensure that the data below the headers is migrated along with the new header location.
Source: Google Apps Script: Add and removed Google Sheets columns based on a search array
One of the major regular tasks that Google Apps Scripts can do for Google Sheets is to automate the transformation of data from one state to another.
Sometimes this task can simply be accomplished by building dynamic templates using the vast functionality of Google Sheets. Other times automation via Google Apps Script is a better tool for the job.
Source: Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets – Yagisanatode
Have you ever experienced the warning about “number of columns in the data does not match the number of columns in the range” when trying to set values or paste a range of values back into your Google Sheet with Google Apps Script?
Check out this post to see how this script can help you fill out your column data to match the number of columns in a range.
Source: Google Apps Script: Filling out your column data to match the number of columns in a range – Yagisanatode
This little tutorial is going to guide us through the steps that will allow us to work, push and pull Google Apps Script code from the online editor to Visual Studio Code.
Related to the clasp CLI from Google, this short guide gets you set up with clasp, installing an auto-completion library, and pushing a project from VS Code to your Apps Script project online.
Source: Working with Google Apps Script in Visual Studio Code using clasp – Yagisanatode
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
In this tutorial, Yagisanatode (@LifeOfSpy) is going to build a simple seat booking Google Form that will contain a registeree’s name and the session that they wish to attend. Each time a registeree submits a request to book a seat for a session, that seat is taken from the list displaying only the remaining seats for that session for when the next user submits the form.
Source: Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode
Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading
Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on How to check if there is a Tick Box (Check Box) in a cell or range
Source: Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode
Use Google Apps Script to get all the emails addresses of the members in a G Suite group, compare that against all the current members in the Calendar and add anyone who is missing
Google Apps Script, G Suite Admins, Google Calendar, Calendar API, AdminDirectory, GroupsApp Note! This article is for G Suite users and admins. You won’t be able to apply the same code to Consumer accounts. Google Groups in G Suite can be a really convenient and clean way to share users to drive folders and file locations, … Continue reading “Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite”
Source: Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite – Yagisanatode
I wanted to update one of my free Google Add-on apps that works with colour. What I had is just the standard HTML color input element where the user selects from the palette and that hexadecimal colour code … had always wanted to create a tool for a sidebar or dialogue box that would allow the user to easily access the standard colours or use the custom palette provided by the HTML color input”
Continue reading this post to find out how you can implement your own copy of the colour picker
Source: Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode