Here’s a nifty little Google Sheet I made to help manage production between multiple clients and project leads in a small to medium-sized group. If you don’t want to spend the money on expensive Project Management systems, this is a good alternative – especially when you’re just starting. You can always upgrade to something that has more options later. I had one I personalized for a crew of 7, so it does the job!

Make sure, once you open the template, you MAKE A COPY on your own drive. Then start being more productive!

PROJECT MANAGEMENT

GOOGLE SHEET

Here’s a basic look of the sheets.  This is where all the fields are filled out..  Each line is job.

Priority
Pretty self-explanatory. Just select the PRIORITY of the job. The color code makes it easy to see from a birds-eye view.
Production Lead
Remember when you put your magnificent name in the “User” field in the “Template Options?” This is where it would show up. Pretty neat, eh?
Timeline
This is when the Project is started and when it’s DUE! If it goes pass the due date, it’ll turn red. Now, eventually, even if the job is completed, the field will turn red. It can’t be all perfect.
Status
Again, pretty self-explanatory. What’s the status. Make it a game. Make them ALL GREEEEEEN! More green, more money, right? I think that’s how it works.
Comments
Track all your comments here. Right-Click on the cell and Click on the Comments section of the drop down. Boom! Insert client communications, issues, why the job is stuck or anything you want!

TEMPLATE OPTIONS

You can replace the “User Name” with something more personalized.  Make it Bob or Jane – I don’t know you’re name, but I’m sure it’s a wonderful name.  Just put you beautiful name here!

I hope this is useful and feel free to modify it to fit your needs.

Simple Google Sheet Template

RELATED RESOURCES

After Effects Quick Folder Structure Script [FREE Download]