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:
This flowchart shows how the system is set up:
The LEN function in Google Sheets is a simple but useful function that counts the number of characters in a given string.
If you’re working with text data in spreadsheets then you’re likely to use the LEN function. It becomes particularly powerful when combined with other functions to manipulate and analyze strings.
🔗 Grab the LEN template at the bottom of this article.
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.
Although AI has been around for decades, it’s only really been available to the public in its current form for the past year or so. And with the rise of these generative AI tools, like ChatGPT and Google Bard, AI is more accessible than ever.
But where does AI fit with Google Sheets?
And how do we use AI tools with Google Sheets?
In this post we’re going to look at how to use the most popular AI tools with Google Sheets. You’ll see how easy it is get started and learn that AI isn’t rocket science. It’s simply another useful tool that can save you time when you work with Google Sheets.
Specifically, we’ll look at three ways to use AI tools with Google Sheets:
Continue reading Three Ways To Use AI Tools With Google Sheets
This automatic data sharing technique first appeared in my weekly Google Sheets Tip newsletter #269, August 2023.
(Don’t miss out! Join today to get future editions.)
This post showcases a unique use case for Named Functions and IMPORTRANGE.
Suppose you want to include a standardized piece of text on the top of your Sheets, e.g. a legal disclaimer or perhaps your company contact details. Sort of like an email signature, but for your Sheet.
There’s a clever trick you can do with Named Functions and IMPORTRANGE to automate this across all your Sheets.
Continue reading Automatic Data Sharing Across Sheets With IMPORTRANGE and Named Functions
