Get Early Access to My New App “Favorite Things” and Unlock the Value of Storing Data in Sheets

Imagine a world like that

When I teach my Excel to Google Sheets courses, I like to start off with a bang and show new users one of the most overpowered (but complex) formulas in the Sheets arsenal, IMPORTRANGE.

Why IMPORTRANGE? It allows you to query data from any other Sheet in your company. This is one of the biggest payoffs for working in the cloud — every other file is already there, waiting for you. As an anecdote (that I have lived to see), imagine your entire company shares a rate card or other all-knowing “SOURCE OF TRUTH” document as an xls you need to reference all the time (if you’re a People person like me, this is a census report of the whole company that I use daily).

Door #1: you keep the excel file or sheet hosted view only and people download it every single day that they need to work with the data.

Door #2: If you’re me, you keep the messy ffs626fs2_u3u8d38d looking Sheet ID on a desktop sticky note, use IMPORTRANGE to query the file, and pull in a range called DATA over and over like =IMPORTRANGE(“ffs626fs2_u3u8d38d”,”data!A:Z”).

But what if there were a door #3?

One thing that makes me sad about Google Workspace is that this particular corner of the suite neglected to take advantage of the “picker” functionality of Drive that lets you browse all of your files from inside an application:

Imagine drawing this up inside Sheets whenever you wanted to reference another sheet

Imagine if you could just search for your favorite source of truth by name, not ID, draw the right range up without even having to open the tab, and get on with your day? Well…

Favorite Things for Sheets aims to free you from a life of open tabs and 100-character formulas by allowing you to do just that — save a favorite range of data and summon it on command. See the demo below:

SEE MY VIDEO DEMO ON LOOM

Interested? Because the app verification process is so time consuming, I want to get the app right first. If you’d like to join the beta release as an individual OR an enterprise/team, please fill out this 3 question form (or email inquiries@maxbrawer.com.

--

--

--

Head of People Analytics @Twitch, formerly @BuzzFeed, Google, Nielsen | Learn from Max @ bit.ly/learnpeopleanalytics

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Rigging the Sanrio election

Leetcode: Minimum Falling Path Sum

💡 How to get started with S-Wallet 💡

Monitoring FTP File Transfers With Automated Processes

Person using laptop to monitor file transfers.

RxSwift vs Reactive Cocoa

Chapter 6 An Interview with Rich Hickey

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
Max Brawer

Max Brawer

Head of People Analytics @Twitch, formerly @BuzzFeed, Google, Nielsen | Learn from Max @ bit.ly/learnpeopleanalytics

More from Medium

Rapidly Build Hybrid Workplace Apps with Microsoft Power Platform — CCS Technologies Blogs

Time tracking with Watson and Jira

Map My Relationships — Visualize & Analyze Dynamics 365 CRM data in Mind Map View!

Developing a digital transformation strategy