KEEP LEARNING WITH THE
Knowledge Base
Work smarter, not harder
Categories
For the up to date content on film production technology, production management solutions, and more, subscribe to the newsletter.
Production Management
Workflow – Less filing, more tracking
No one likes filing. It’s time consuming and doesn’t add any value to the production. But, we’ve all received that call from a random crew member, 6 months after wrap, inquiring about a check for $42 and 3 peanuts that might not have been cut. And that’s when filing pays […]
Workflow – New projects
One of the key issues with new media production companies is the sheer amount of unique projects. Each project needs to be recorded somewhere and referenced for each cost impacting it. Based on my experience, here is a good workflow to keep track and make projects accessible: Project initiation Set up an […]
Reviews
Google Sheets
The Basics – Conditional formatting
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 […]
The Basics – Vlookup
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 […]
The Basics – Data Validation
Have you ever wanted to have a dropdown menu for the positions in your crew list? Well that’s what we’re doing today! This is extremely useful since it will: Save you time by removing some data entry insure that you always use the same nomenclature, and thus making filtering and […]