Welcome to issue 12 of the Sheets Insiders membership program.
You can see the full archives here.
Jan schedule for the Apps Script course
Start 2025 with a bang!
Join us to learn how to use Apps Script and AI tools to automate your Google Workspace workflows.
Over the course of 3 weeks, we’ll learn the basics of Apps Script and create a useful automation tool you can use in your own work.
We’ll leverage AI tools to build quickly and efficiently.
Workshop 1: 9th January 2025 @ 12pm – 1pm EST
Ideation and basics of Apps Script
Workshop 2: 16th January 2025 @ 12pm – 1pm EST
Using AI tools to help us understand and write Apps Script
Workshop 3: 23rd January 2025 @ 12pm – 1pm EST
Putting it all together to build a useful Sheets automation
Note: All the recording and templates will be available afterwards to all Sheets Insiders members, regardless of whether you register.
A Holiday Formula Challenge
If you want a challenge over the holidays, see if you can create a single formula that calculates the number of times Christmas Day occurs on each weekday in the next 100 years.
I.e. it should look like this, where the table is generated by a formula in A1:
Hints
- Build up in steps
- Start with a SEQUENCE of 100 for each year
- Convert to Christmas date for each year
- Calculate weekdays and summarise
Answer
See you next year
Happy Holidays and Best Wishes for 2025!