To-Do Task List Management in Google Sheets 

Glad it was helpful, and thanks for the purchase! 😀 There is also another template available with a calendar, make sure you check that out too 😉

Thanks for the support 👍🏻

Thanks for the comment 👍🏻

Thanks, it's comments like these that make it all worth while 😊

Thanks @micahmalloy, I really appreciate your comment, I’m glad you liked the vid 👍🏻

Thanks @JavierOropeza08 👍🏻

Hi @user-gl4fr6tf8x, You can adjust and add labels and categories in the settings sheet in the ranges G4:G13 and H4:H23, respectively. You can add up to 10 labels and 20 categories with this template.

Thanks! 😊

That's awesome to hear, thanks for the feedback 😉

Great to hear! Reference - To-Do List Task Tracker with Calendar Template: bit.ly/task-tracker-with-calendar You could add a filter row on row 4 for each status sheet. Just select row 4 and then go to the menu and choose Data > Create a menu. Once this has a filter applied to it you can sort each table or filter by category or priority for example. Hope that helps!

Thank you so much @yeimyfranco7625 you're very kind 🙏🏻 😊

Yes, you can use the Sort Table menu option under the Task Board menu. The Project Management template includes sorting for any column using a button, which is easier: bit.ly/project-management-template

Hi @theBabylady, I'm afraid it's not Google Tasks, these will be isolated to the spreadsheet, however, I do have another template with a built-in calendar to show tasks within a calendar in the spreadsheet. You can find this in the video description called 'Pro Task Management with Calendar Template'. You could set up a script to send you an email when tasks are due using this sheet. I can also help you with that if you would like to customise one of my templates. You can contact via my website with your requirements if this is something you'd like to explore. Both templates are on discount right now via Etsy or on my website - links in the description box 😉

Hey @jabigaeltan, Thanks for your message. You can add another tab, sure, but the Apps Script that runs the automation does refer to those specific tab names there already, so as long as you don't change the existing sheet names you should be fine. PS, thanks for your order of the Pro version 👍

Thank you for your order! If you would like to assign tasks to others, you would need this Project Management template, which is the next template up from the one you purchased. spreadsheetwise.etsy.com/uk/listing/1621270506/project-management-template-with I have messaged you separately about the modifications 👍🏻

Hi there! Thanks for the order. It would be best to contact us via the website for assistance on this. 👍

Thanks! Do you mean sharing the sheet with others?

When you create a task using the Add Task Sidebar the sheet will automatically create a Google Doc and link it to the task title for you, but if you add tasks manually row by row, the automatic Google Doc will not be created or linked.

Sure, this is straightforward. I’ve included instructions on how to do this when purchased, it’s just a few clicks and you can have M/DY or D/M/Y 👍🏻

Hi there, each user effectively has to give the sheet permissions to run on their account to create Google Docs etc, therefore the folder will reside locally for each user and not within a shared drive. You can share the Task Board folder with other users, but every user will have the same folder name, so you'll need to consider a folder structure to organise tasks across a team. I see you ordered the Pro Task Management template bit.ly/pro-task-management but you might find that the Project Management template is more suited to teams as you can assigns tasks to people on this template: bit.ly/project-management-template When you create a task using the Add Task Sidebar the sheet will automatically create a Google Doc and link it to the task title for you, but if you add tasks manually row by row, the automatic Google Doc will not be created or linked.

Hi It's possible to add additional sheets/steps but the Google Apps Script will need to be updated to reflect these extra steps. You can contact me via my website to discuss further if this is something you wish to explore. Connecting it to Gmail labels is a whole different level of complexity, which this sheet is not capable of I'm afraid. If you want this sort of synchronisation between tasks and Gmail, you might need to consider an off-the-shelf solution for task management and use a service like Zapier to automate these changes as what you talking about would get very complicated using Apps Script in Sheets and Gmail.

Hi @lorienglish844 Great question! When you purchase this template you will be prompted to make a copy of it in your drive. Once you have it saved in your drive you can then head to the menu File > Make a copy to make further copies of the same template within your drive. This will make unique copies of the same template for managing various projects. You will need to run through the permissions process on each template as each one will be unique and you'll need to give the sheet permissions in your drive. If you need anything just drop me a message via my website or via Etsy. Good luck! 😉

@@spreadsheetwise thank you! I will get in there today to purchase a template. I am really looking forward to using this.

@@spreadsheetwise This sheet looks great and I'm about to buy it, I just have a small question : would it be possible to make multiple copies of the sheet without them interfering in the calendar ? Let's say for exemple I want a specific sheet dedicated to my school study, then another one for music etc.. Will it create a calendar for each project or would it be possible to gather all tasks from different projects into one calendar ? (I'm talking here of the pack containing the 'Pro Task Management with Calendar Template'.) Thanks in advance !

When you purchase this template you will be prompted to make a copy of it in your drive. Once you have it saved in your drive you can then head to the menu File > Make a copy to make further copies of the same template within your drive. This will make unique copies of the same template for managing various projects. You will need to run through the permissions process on each template as each one will be unique and you'll need to give the sheet permissions in your drive. Each sheet will display tasks on the calendar respectively, so if you had two copies of this template, you would have two separate task calendars; they would not be linked and they are not linked to your Google Calendar either, they are just standalone in the sheet for tasks. Hope that helps.

@@user-zn2rt2kd2c When you purchase this template you will be prompted to make a copy of it in your drive. Once you have it saved in your drive you can then head to the menu File > Make a copy to make further copies of the same template within your drive. This will make unique copies of the same template for managing various projects. You will need to run through the permissions process on each template as each one will be unique and you'll need to give the sheet permissions in your drive. Each sheet will display tasks on the calendar respectively, so if you had two copies of this template, you would have two separate task calendars; they would not be linked and they are not linked to your Google Calendar either, they are just standalone in the sheet for tasks. Hope that helps.

Hi @brittanynicolephotography Thanks for reaching out, please drop me a message via the website so we can discuss your requirements. 👍🏻

Hi there! It is possible to adjust the names for the task statuses but this will require changes in the Google Apps Script and within the spreadsheet. It's advisable to contact me via the website so we can communicate via email to discuss your requirements.

What is the email that I contact you at. I went to the website, do I just leave a question there?

Please go to the 'Contact Us' page to submit a support request, thanks.

Hi @ken125y You should check out this template which allows you to assign tasks to people in your team: bit.ly/project-management-template

@@spreadsheetwise I looked at that. It doesn't contain the feature I was looking for. I didn't explain myself properly. I don't want to merely assign tasks to people on my team; I want them to be able to manage tasks I assign to them in, well, ummm, in To-Do Task List Management in Google Sheets just like I can. Your model is analogous to air traffic controller communicating with airplane pilots; my model is, well, it's the way colleagues normally work with one another. Technically I suppose it might work like this: when I choose to assign a task to a member of my team, let's call him Joe, the GAS would create a link to that task I had created in Joe's "To Do" tab. There would be a column called "Assigned By". For tasks I had assigned, the name would be "Ken." Joe wouldn't be able to move that task without my permission (because I would "own" the task). If Joe completed the task he'd need to try to mark it as "Completed", but he'd see a message, "Please type a brief message to Ken indicating why you would like him to mark this task as complete." Then, GAS would update a cell under a column labeled "Assignee Request" To-Do Task List Management in Google Sheets with Joe's message such as, "Are you kidding? I'm not going to do this! Just kidding, I completed it. Please see my comments in docs.google.com/document/d/1fqitEv-9BQS1WLIKcaxuuxiIxNTNPpjRz1mBBKiq3Ik" Next to the "Assignee Request" column would be a column labeled "Approve or Deny Request." which would normally be blank, except in the case a request had been made. In Joe's case, radio button with 2 labels would appear: "Approve request" (to mark the task as complete) or "Deny request" (which would not mark the task as).

@ken125y Obviously, I would appreciate individual sales to support the work I do, but yes you could do this; it cannot be resold by you or anyone you share this with. Please note any after sales support required can only be offered to paying customers.

Can you confirm your order number so we can check please?

@spreadsheetwise I got the free one (for now), and they/the tasks don't move in between the sheets.

@@TheTld007 Did you rename the sheets or status names by chance as the Google Apps Script uses these specific names to move the tasks based on the status and sheet names?