Think Like a Programmer | Develop The Mindset of an Apps Script Coder
•Don't memorize. Know where the information is
•Read the documentation
•Try things. Go for it!
•Seek out errors.
Andrew Kamphey
Automate Google Sheets without Apps Script, without Zapier
I've been doing a lot in spreadsheet automation using Apps Script. But I wanted to go back to some formulas that I think feel like magic. They make me feel like a wizard without having to code.
Google Sheets Error: Unknown Range Name and How to Fix it
A user asked me about an error, which is the "Unknown Range Name." By the time you’ve read this tutorial, you’ll know how to fix this error.
What is the Unknown Range Name error?
It’s an error that you get when the value that was
Most Common Errors and How To Handle Them in Google Sheets
Most Common Errors and How To Handle Them in Google Sheets
#N/A error
#REF! error
#NAME? error
#DIV/0! Error
#VALUE! Error
#NUM! error
#NULL! error
Organize Your Data! - Build a Kanban Board / Trello Board
Effortlessly organize tasks using Google Sheets! Learn impressive formulas, create Kanban/Trello boards, and optimize your life and workflow.
Every Locale Listed in Google Sheets and a Tool to Save Your Sanity
If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create a Google Sheet formula and then you copy and paste it into your sheet and it has the wrong delimiter. How do you resolve that?
Make It Easier For Others To Use Your Google Sheets
In this tutorial, we're going to orient users better in Google Sheets. We want to help not just ourselves but also anyone who’s going to use a spreadsheet that we have created.