Ben Collins Blog
28 FOLLOWERS
Hello! I'm Ben Collins, an educator, writer, developer, and founder of The Collins School of Data. I create online courses and write about Google Workspace tools. I focus on data analysis and automation, using Google Sheets and Apps Script. I love building lightweight, data-driven applications for the Google stack: Google Sheets, Google Data Studio, Google Apps Script, Google Docs, Gmail, etc.
Ben Collins Blog
2M ago
Smart Chips in Google Sheets allow us to add richer information to our Sheets, beyond the standard data contained in cells. They help us work more seamlessly by bringing information from external sources into our Sheets. In this post and video, we take a comprehensive look at the smart chip feature. You’ll learn what they …
The post The Complete Guide to Smart Chips in Google Sheets appeared first on ..read more
Ben Collins Blog
3M ago
In 1956, a 13-year old Bobby Fischer announced his chess genius to the world, winning one of the finest games in chess history. In fact, Chess Review called it “The Game of the Century“. In a game full of beauty and surprise, Fischer overcame his much older, more experienced opponent, the International Master Donald Byrne. …
The post Play-It-Through Chess Game in a Single Google Sheets Formula appeared first on ..read more
Ben Collins Blog
3M ago
Filtering with dates in the Query function in Google Sheets can be tricky. In a nutshell, the problem occurs because dates in Google Sheets are actually stored as serial numbers, but the Query function requires a date as a string literal in the format yyyy-mm-dd, otherwise it can’t perform the comparison filter. This post explores …
The post Filtering With Dates In The QUERY Function appeared first on ..read more
Ben Collins Blog
4M ago
This is Annual Review number nine! That makes this the longest career stint I’ve had. Woohoo! ? (Before this, I was a Forensic Accountant for eight years.) 2023 was a great year. Of course, it had its ups and downs, but my family and I are all healthy and safe, which is all that matters. …
The post 2023 In Review And A Look Forward To 2024 appeared first on ..read more
Ben Collins Blog
4M ago
This post describes how I designed and ran an audience survey with over 1,700 responses, using Google Forms, Sheets, Apps Script, and ChatGPT. I’ll show you the entire process from end-to-end, including how I: Created a survey with Google Forms Used Apps Script to automatically say thank you to 1,700 respondents Analyzed the response data …
The post How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses appeared first on ..read more
Ben Collins Blog
5M ago
The ROMAN function in Google Sheets converts numbers into Roman numerals. This function is particularly useful for those interested in presenting numbers in a classical style, whether for educational, historical, or aesthetic purposes. ? Grab the template at the bottom of this article. ROMAN Function Syntax =ROMAN(number, [rule_relaxation]) It takes two arguments: number: The number …
The post The ROMAN Function in Google Sheets appeared first on ..read more
Ben Collins Blog
8M ago
This post was born from my ongoing experimentation/obsession with the SPARKLINE function in Google Sheets. We’ll see how to create a Join-The-Dots game in Google Sheets using only the built-in formulas, no code. ? Grab your own copy of the template at the bottom of this article. ? This Join The Dots game works using …
The post Join The Dots Drawing In Google Sheets appeared first on ..read more