Grad School Application Tracking Spreadsheet

I made spreadsheet to track my grad school applications and I thought some of you might like it as well. Use the link to see the preview and download the template.

It includes scripts to highlight the line on the "General Tracker" sheet in either red or green depending on admission status from the dropdown menu, as well as scripts on the individual university sheets to strikethrough the required materials and LORs as you check the boxes off. It will also change the color of the tabs to red, yellow, or green to match the application status dropdown on each individual university page.

You may need to navigate to "Extensions" and open "Apps Scripts" and run them to get them working. If that doesn't work, copy the script codes for "Accepted/Rejected, LOR Checkboxes, RM Checkboxes, Strikethrough, and Tab Color", and paste them on a doc. Then use the three horizontal dots to delete the corresponding scripts. Use the plus sign at the top of the script list to add new script, title it what you'd like, paste the corresponding script, select the floppy disk to save, then run. Do this for all scripts, and the document should do all the above.

https://docs.google.com/spreadsheets/d/1lvYANFyrk6tUJ78MHfDH7uwe1-vUou5Bxn2PGdwq5YM/template/preview