Hi there,

Google Sheet allows access from the desktop, mobile and when offline. I use Google Sheets to keep my To-Do list, grocery shopping list, etc. For my Easy To-Do list, I have Google scripts to refresh the list when a cell gets updated. The refresh sorts when a date is changed, advances the date when a repeating task get ticked, adds an empty row after it has been consumed ... etc. It is much easier to use.

I am wondering if this can be useful for others. I share this Easy To-Do in my Google Drive for your comment:

https://docs.google.com/spreadsheets/d/1M40gq6K4hmce3ubf9T9TJalVQatSCKkOfduoAf5qKAk/copy

If this is useful, I will share my other Google Sheets.

update: I published the script as Google Addon that you can plug into your existing Google sheet to-do list. Please type "To-do list plugin" to search my addon.

If anyone wants spreadsheet templates, here's my template collection https://docs.google.com/spreadsheets/d/1DVotXIefnYy0T6bap_BUdft0oEn9svOKrahu-kE-JDc/edit?usp=sharing

All templates have a guide and example data in them and you'll have to create a copy to use it for yourself. My current personal favorites are the Club finances and Assignment tracker, they're most relevant for daily Drexel life and I'm very proud of them.

If you have any questions or comments please reach out to me, I'm always looking for ways to improve my sheets and make them more user friendly. If you do use a template of mine, feel free to comment or dm me and tell me what you think! I love hearing about people using my sheets and what they've done with them.

Shift hours: This sheet is customizable and useful for keeping track of any shift work, or anything that you spend multiple hours on like volunteering, club activities, and hobbies.

Personal budget: Exactly what it sounds like. This sheet is to keep track of your personal budget. If you have online banking, you can export the csv file and paste it directly in here. However, you do have to go through and categorize all purchases yourself.

Club finances: If you are a club treasurer or know someone who is, this is a fantastic resource to keep track of club finances. It includes both the 17 and 19 accounts and makes it very easy to see where your club money is going.

Coop interviews: Tracker for Drexel co-op interviews. You can also use this to keep track of any other interviews, but I'm not really sure when else you would be applying to like 10 jobs all at the same time.

Weekly schedule and deadlines: Weekly calendar! This is just to have a nice visual of your weekly classes, and the deadline tracker is fantastic for exams and projects. If you go into your syllabus and put the dates in, the automatic color changes makes it easy to stay on top of what's coming up.

Assignment tracker: Beefed up deadline tracker! You can use it to log when you have assignments due and when exams are coming up, as well as your progress status on each. It's great for staying on top of deadlines and making sure you get your work done on time.

Academic 4 year: Exactly what it sounds like.

Academic 5 year: Exactly what it sounds like.

Hello. I have all of my tasks on a spreadsheet. Is there a template for repetitive tasks, as well as a dashboard that shows only the tasks for today?

I would like to know if anyone knows of a free task template where you can check a box when you finish a task and if you don't the unfinished task moves to the following day and so one or to a different list of incomplete tasks.

Also, how could I make a task sheet where the most important stuff be always at the top and whatever I finish could be at the bottom of the sheet?

Thank you all.

Hey Boilermakers!

We all know that in order to be successful, you have to be able to keep track of the assignments, reports, exam schedule, etc. for multiple classes. This is difficult when all the due dates are in different places, so we developed a FREE Google Sheets template to help you organize everything in one place!

The template has a ton of very cool features, such as:

• Space to include your schedule and professors

• Assignment status bar with five options

• Filter to sort assignments by due date

• Automations that give you a warning when assignments are due in two days or less, highlight assignments based on which class they belong to, strikes assignments out when they’re complete, and more!

• A calendar that autopopulates assignments based on due dates.

• Full instructions on how to use and customize the template!

We spent a lot of time on it, and would love if you tried it out! You can find it here.

For more study tips, resources, events, etc. Follow HHS Student Life on Instagram!

Just a quick post to share a Todoist Template Generator I've created using Google Sheets. It may be of interest to some on here.

Its objectives are twofold:

• Take the pain out of setting up templates for repeatable projects that have a set timeline / critical path

• Ensure that the timelines of these templates can be easily adjusted so the whole timeline dynamically adjusts should you change the 'start' date to a future date - user selected.

The Template Generator does much of the heavy lifting, ensuring correct and consistent syntax is automatically applied when adding content to the template.

The workbook contains full instructions on how to use. Note that it's 'as is'; it's something that I find handy that I'm sharing, but will not be doing further work on. By all means feel free to edit your copy and build on the groundwork if you feel inspired.

To use, just click on this link and then on the blue "Make a copy," button to add the spreadsheet to your own Google Sheets library. If you need it in Excel (.xlsx) you should be able to download a file in that format from within Sheets if required. I've not tested it in Excel, but seeing as I'm not using any functions peculiar to Google Sheets (apart from the Apps Script, Clear Range Macros), it 'should' work in Excel.

So there you go. If you find it of some use, that's great. If not, no worries at all. Cheers!

UPDATE (30/3/20)

Just to flag that I added a custom menu to the sheet (Reset Ranges) to make it easier/more accessible for resetting the user-input content on the template. This is Apps Script driven, so you'll need to authorise as per instructions given before.

Note - If you wish to use this new version with the custom menu, you will need to make a new copy from the link above. Cheers.

UPDATE: Anyone looking for updated sheets / other sheets check out my new Etsy shop Redditors get 50% off. I'm just looking to grow it right now so if you found my sheet helpful I'd really appreciate a review or a purchase: https://sheetsbyjulia.etsy.com?coupon=REDDIT50 access to the most basic and updated version of the sheet you can fill out this gform for access and you can choose to subscribe for future sheet developments/tips: https://forms.gle/CMnQviMBQrhv8bcw8

I used to use Notion to manage all my tasks and projects when I was in college, but upon graduating and starting a full time job (while trying to continue working on projects on the side), I realized I need a more simplified to-do list system. I wanted to just opening something up when I arrive at work or have a time block to work on side projects and knowing what pending tasks I have.

I've tried Google tasks, Motion AI, Apple reminders and other random to do list apps from the app store but it was all too complex and lacked the customization I needed / Motion was so expensive and I wasn't really using all its features.

I made this sheet that automates adding to Today's Agenda the tasks I have for that day, syncs between my task list and Today's Agenda if I check something off, and every day at 1am flushes out all the completed tasks to the Completed tab. I also figured out how to make a web application using google scripts so I can see my tasks / add tasks quickly using apple shortcuts.

I made a template version for my friends and family, and I'd love to hear what people think / ways to improve it or suggestions to make my workflow more efficient.

For our company we use one Google Sheets file for all our project management. I'm sharing here as a walkthrough because there's too many unanswered questions in r/projectmanegement, and because I want to start a discussion and see how it's different from what you do.

We are an international team with ~20 people. We pay $12 per month for access to G Suite and then we have a share folder which we share with all other people. So effectively this is less than $1/user/month.

This is a quick view for each task. (Maybe other people call these projects.) Our rule is that all active tasks must have weekly status updates. We have instruction files for each one and there is a link. Other hidden columns off the right include Status Update Text. Here are the other tabs:

• Work log -- people log hours here, this is how the HOURS on the Tasks tab will calculate, our rule is that these must match submitted time sheets

• Outreach tasks -- some additional details we track for content marketing projects

• Workers -- a list of each worker, their Slack identifier and other data

• Calendar -- each column is a team member, each row is a date, people mark what days they are working

We use the above collected data in some useful ways. First we suck this whole file into our MySQL database hourly. (See on GitHub google-sheets-etl, we open sourced this.) We have all kinds of exception reports and performance reports. If you forget to update the status on an active task then you and your manager will get a message on Slack. If your task is overdue it will show up on our intranet tickets list. If you are scheduled for vacation today, your face is grayed out on the TV in my office.

Our biggest pain point was just a normal failing of Google Sheets: you can't lock down formatting or data validation for a cell. We use formulas, conditional formatting and more to make this work. If somebody types a date into the wrong cell and then copies it to the date column then bam our formatting and everything is now broken on that cell. We work around this by using protected cells in most places -- and more exception reports.

I have looked at other project management tools. First, they want everyone on my team to have a separate account login -- it is hard enough to get my team to login to Gmail. Then they want to bring me from $12/mo to $300 or more. Lastly, they want to lock up my data so I can't pull it every hour and use it elsewhere. Every one of them has a stupid animation to explain how their product works without actually showing the product. Google Sheets on the other hand is mostly free, or price does not go up when I add people, is easy to understand, everyone is already logged in and it connects with my intranet. For me it is just lightyears ahead of all SaaS out there.

Does anyone know of a good blog or website with easily usable Sheets templates for multiple purposes?

Hi all,

I'm starting to organize my life out on Google Sheets for everything (Finances, Gym workouts, Tasks etc.) and was wondering - what's your version of "Google Sheet for Life Plan" look like? What template did you DIY to make sheet work for you?

P.s P.s, template links are highly encouraged for both me and other readers in this sub

It occurred to me while on my daily walk that it might be possible to keep a Todo list in Google sheets yet use zapier or app script to "scrape" the task list nightly and email a daily todo list per the parameters you specify.

Anyone doing this?

I saw that there are templates for tracking book you read and they are all aesthetic and organized, but I want one for tracking shows that have drop down menus and other features. If there are any you know please lmk. THANK YOU SM

Hello everyone!

Don't use reddit often, so I hope this is an okay place to ask for this, and if this is not the right place for this type of question feel free to ignore or redirect. I don't really know if this is something thats even possible to do in google sheets, but figured I'd ask anyways :0]

What I'm looking for is if anyone knows of any templates with the capability to create new "groups" or "categories" as well as to create "sub-categories" with topics on each sub-category at the press of a button on the side. I'll attach an image below, it's not pretty but I think it shows kind of what I mean. I've looked at a ton of different templates, but haven't found something that fits. If that type of template doesn't already exist, I'm completely willing to pay for a custom one.

(Please excuse the fact I'm probably using the wrong terminology for what I need, I'm not very good at explaining things)

This thread is the place to show off any projects you've been working on, show off fancy solutions, etc. If you've got some templates to share, also post them here.

If you're looking for feedback on your project, let us know! If you're looking for specific help, make a normal post.

This is a monthly thread.