You can use =today()-30 to set a cell's value to the last calendar month. To create a column with a rolling 12 month you can iterate the cells in a column by 30. =today()-30=today()-60=today()-90=…
Shane Rice
A collection of 37 posts
#WorkFromHomeDay
It’s #WorkFromHomeDay! Here's my story of transitioning from working in an office full-time to a full-time remote job. The first time I realized you could work from home was 2001. My friend Tom worked from his shop doing sales…
Taming GitLab's Google Tag Manager container
When I joined GitLab, there were layers, upon layers, upon layers of tags and triggers in our Google Tag Manager (GTM) container. It was hard to troubleshoot and maintain. This is the story of how I tamed it.
Cleaning up your GTM container in Google Sheets
One project I've tackled at GitLab is cleaning up our GTM container. Our container is a few years old and is full of cruft, and I want to clear the cobwebs. This means I need to move our active components…
Share what you know
Yesterday my friend Matt mentioned he wanted a simple way to share a song or album with his friends regardless of what music service they use. You know how there are services that let artists share a landing page with…