First add-on published

My first Google sheets add-on is published! To be totally honest, I made it mainly to see what was involved. I really like the work that Andrew Stillman has been doing with New Visions for Public Schools, including Doctopus and formMule, and I wanted to see if I could do similar things for higher ed or international… Continue reading First add-on published

Tuesday tip: Google add-ons

Earlier this year, Google unveiled add-ons. Previously, developers could use Google Apps Script (GAS) to create custom functions or tools, then publish them to script gallery. Other users could then read a short description if the script and install it in their own files. It worked fine, but it was clearly something Google hadn’t put… Continue reading Tuesday tip: Google add-ons

Tuesday tip: Spreadsheets and sheets in Google Apps Script

This week’s tip is a follow-up to last week’s post on working with ranges in Google Apps Script (GAS).  Just like ranges, you need to be careful that you are working with the correct object if you’re dealing with sheets in GAS. If you’re used to Excel and VBA, GAS vocabulary is slightly different. In Excel, the… Continue reading Tuesday tip: Spreadsheets and sheets in Google Apps Script

Sharing limited data without sharing the whole spreadsheet

Recently a friend asked me how he could share some data that he was working on with colleagues. The problem is that he can’t share the entire spreadsheet. My suggestion is to use Google Spreadsheets and the ImportRange function to share limited ranges with another spreadsheet. What’s great about this method is that you can… Continue reading Sharing limited data without sharing the whole spreadsheet