Anyone who regularly works with spreadsheets knows the anguish of screwing up said spreadsheets.
It usually goes like this. You’re powering through – filtering, sorting, formulating – until you notice that one row of data looks off. After frantically checking a few more rows, it hits you. Something went wrong in your manipulations, and now you need to start from scratch.
Spreadsheets are great, but they have also destroyed many a nonprofit worker’s day. Fortunately, we can do things to reduce the chance of this happening…and keep calm when it inevitably does.
Don’t worry – nothing actually offensive took place on my part. My job isn’t in jeopardy, I’m not on probation, or anything like that! But I had an exchange with one of my directors, and as far as I’m concerned, I’ve definitely made a mistake in my role. Let’s dive in.
Anyone who manages a database knows that the job has it’s less-than-glamorous moments. Not that anyone would call this work glamorous…which is precisely why I love it.
Whether your nonprofit is using it or not, let’s talk Google Forms for a second.
In case you’re not familiar, Google Forms is a survey app that comes with the Google Suite of products. Much like Google Docs and Google Sheets, it has its own place in the G-Drive and lets you easily build form surveys.
Google is not sponsoring this post. I’m not even claiming it’s the best survey tool out there. BUT, it’s worth highlighting for three very nonprofitty reasons:
It’s accessible. Even if your org doesn’t use Google products, you could sign up right now to build your first form with no fuss.
This means that Google Forms has many applications for our work, regardless of how large or technologically sophisticated the org. A simple tool that can do all the things? Prettyyyy cool.