Tracking application status (Google Sheets)

[Chris K]

By the way was @Paul J. the one who originally created this document? How the heck did you do the pulldown options for applied etc... that's great.

Hi @Chris W

This should do it: Create an in-cell dropdown list - Computer - Docs editors Help

 

[patchoooli]

A restored (AND LOCKED) 2015 version is here:

Film School Applications 2015

A restored (AND LOCKED) 2016 version is here:

Film School Applications 2016

And an ONLY 2017 version is here:

Film School Applications 2017

Thanks Chris. This is such a great website/forum

 

[Rulin]

Hey guys,
May I ask is there anything wrong with the 2017application form?
there are only three school displaying in the table on my computer, AFI USC and chapman.
Just want to make sure is it a question of my own computer? or does anyone have the same error with me?

 

[Kira]

Hey guys,
May I ask is there anything wrong with the 2017application form?
there are only three school displaying in the table on my computer, AFI USC and chapman.
Just want to make sure is it a question of my own computer? or does anyone have the same error with me?

It happened to me as well. I restored it to a previous version so hopefully it'll stay.

 

[Rulin]

It happened to me as well. I restored it to a previous version so hopefully it'll stay.

That's cool！~~You are so great!~~Thank you guy!~~

 

[ireneyang]

I just noticed the "notes" column is gone in the new 2017 form Does anyone know why?

 

[ASF]

I just noticed the "notes" column is gone in the new 2017 form Does anyone know why?

Fixed it. Just two columns were hidden - someone must have done it by accident.

 

[CSBBATSE]

Thank you to whomever put this together.

 

[Chris W]

Thank you to whomever put this together.

I'm not positive who originally did it... although I do know that @Paul J. was a huge proponent of getting it started.

 

[IndecisiveElle]

Should we start our 2018 spreadsheet soon?

 

[Chris W]

Should we start our 2018 spreadsheet soon?

Probably Yes.

Here they are:

Graduate Film School Applications 2018

Undergraduate Film School Applications 2018

 

[IndecisiveElle]

Probably Yes.

Here they are:

Graduate Film School Applications 2018

Undergraduate Film School Applications 2018

I can't believe I'm doing this again. Haha. Third time the charm?

 

[BadouBoy]

Third time the charm?

It's my 3rd round as well- I certainly hope so! Lol

 

[Chris W]

Updated doc with application date column.

 

[Zeno]

It's my 3rd round as well- I certainly hope so! Lol

I can definitely empathize Elle, BadouBoy. This is my round two. It's called grit! And you guys have an extra year on me so even more grit! Here's hoping we all put it over the line this time!

 

[mistah_P]

I was reviewing all the tracking sheets from 2015-2018, and couldn't help but think that two columns might also be useful to understand how to handicap application chances:
1. In industry experience in years
2. Age

What do y'all think?

 

[arjunajayawardena]

Any particular reason why the MFA program at DePaul is not here?

 

[IndecisiveElle]

Any particular reason why the MFA program at DePaul is not here?

Forum members enter their info themselves, so if it's not listed, then no one who applied entered their information. Feel free to add yourself.

 

[Chris W]

Have people not been able to edit just with the link? I've been getting a lot of requests to edit but one should be able to edit it just with the link. Hmm.

 

[IndecisiveElle]

Have people not been able to edit just with the link? I've been getting a lot of requests to edit but one should be able to edit it just with the link. Hmm.

I had to request it earlier today. I wonder if the settings for how the docs function as a whole was changed? I know google has been changing some permissions with docs and drive.