Image for post
Image for post

Ever had a long formula with references to other sheets that was too confusing to follow?

I recently started a new job where I needed to ramp up quickly on a formula heavy model in Google Sheets. In the past, I relied on a custom Excel Add-On I built that helped me easily navigate through cell precedents and dependents using keyboard shortcuts.

Unfortunately, Google Sheet doesn’t have the same built-in tracing functionality like Excel which served as the foundation for my custom-built VBA scripts.

Luckily, Google Sheet is powered by Google Apps Script and with a bit of regular expression magic, one can build a Sidebar that can help list out all the cells that a formula of another cell is referencing. …

This detailed walkthrough will let you build a tracker for email opens using Gmail, Google Sheet, and Google Apps Script. Functionality is kept to a minimum, but I’m happy to expand for other use cases if you leave a comment.

By the end of this tutorial, you will be able to do the following:

But first, a brief explanation of how tracking email-opens works and why you may see possible false-positive or false-negative results.

To track whether an email was opened or not, most services use a web beacon or pixel. …

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store