Google Sheets

A collection of useful formulas, peculiar syntaxes, and other tips for building production office spreadsheets.

Note: The content of this article is now outdated, but the logic remain the same. I highly recommend Ben Collin’s article on the subject to help you achieve your data scraping goals. Every production company wants to know if the content it produces is worth what it costs to make Read more

Array formulas are all about efficiency. In previous posts, I told you to simply copy and paste a formula from one row to an other in order to replicate it. I didn’t want to complicate things then, but technically, I was giving you an inefficient way of doing something. In Read more

This is a short post about a tiny, but useful feature. Naming a range is, simply put, the ability to give a name to one of several cells. This name can then be used instead of the alpha numeric reference to the cell. Named ranges can be used in formulas Read more

Just like excel spreadsheets can be connected together, Google Sheets offer the option to link data. Except it’s a lot better because you don’t need to open both documents to get a live feed. Uses Importing data serves three main purposes as far as I can see it: It’s a way to Read more

Setup What is a cost report, if not a filtered and organized list of items? Generating cost reports is, for some reason, troublesome for many. Every production department is of course backed by one or several production accountants, who’s responsibilities include generating these reports. But in practice, all the information Read more

it’s a lot easier to spot information with color than with anything else. We all know that red is bad, and green is good! I’m going to show you how conditional formatting can help you and your team in every day documents. Edit: I just finished a video showing you how Read more

Wouldn’t it be great if the account coding appeared by itself whenever a position is selected in your crew list? Vlookup is one of excel/google sheet’s most useful formulas. It’s used in many situations, and looks like pure magic if you’re not familiar with it. There are tons of tutorials Read more