Four-legged friends

This month’s post is a bit different from the usual, as we celebrate a team effort of inventing ice breakers for our weekly team meetings, which take place for an hour every Wednesday morning. We’ve got everything from “share your four-legged friends” to “lockdown recipe swap” to “pandemic playlist” to “humble brag” to “Pictionary Jam” and more.

Recording an AutoFill with the Macro Recorder

Google Sheets users can already use the magic of AutoFill to expand data automatically detecting a series of numbers, letters or dates. This feature is particularly powerful even when your series includes text or repeating dates. In this post I’ll highlight how you can also use AutoFill in your Google Apps Script projects

Google Sheets charts in your inbox

Back in 2015 I shared a post on Tips on emailing inline Google Charts from Sheets using Apps Script, which looked at how you can email charts from Google Sheets. This solution is one I use in my work on a daily basis and remains largely unchanged. More recently I was faced with the problem that I couldn’t include a Combo Chart. In this post I revisit this problem and share a solution for including copies of your Google Sheet charts in your email reports.

Meeting around a document by Visual Thinkery is licenced under CC-BY-ND

We are using this approach to create some space to think together in ‘unprecedented times’. It’s open leadership in practice and in pandemic times. For regular readers this is a slight departure from our regular ‘Virtual Teams’ posts taking a broader view of work whilst midst global pandemic.