Scripting in Google Sheets

AndyCr15 · 27 Apr 2019 at 17:06

We use Google Sheets at work, we export a lot of our data into Google Sheets and I was thinking how easily I got stats and analysis on this data if it was actually a database.

This made me wonder, maybe I should learn how to script and such in Google Sheets? Does anyone have any advice? Is it based on another language? Can anyone recommend a decent online course?

Thanks.

AndyCr15 · 28 Apr 2019 at 14:01

Thanks, I want to be able to do things at work with work documents. I can't even plug in a USB stick and access that, let alone install software or import things into databases

AndyCr15 · 29 Apr 2019 at 19:46

Thanks, some good information.

An example of something I was wanting to do -

[Name] - [Employee #] - [Line Manager] - [Most Recent Review Date]

I wanted how many employees each line manager had that had not had a review in the last 6 months. I think I could work that out quite easily as a MySQL query, but wouldn't know how to do it in sheets.

AndyCr15 · 30 Apr 2019 at 14:59

Well, I'd need to count them grouped by line manager, but yes. Just now having a look at the query function. I didn't realise you could basically use an SQL query in Sheets. (Now looking through the Ben Collins link above.) Thanks.

AndyCr15 · 30 Apr 2019 at 16:05

Nope, you can use GROUP BY in an SQL command and count how many in that group and you can apparently do it in Google Sheets. I didn't realise you could use Psuedo SQL in Sheets... this will be fun!

Pretty much got it working, bar the date, which it reads from a different cell where the date calculation goes on. I find dates and date formats are always a massive PITA in coding