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.
Hi @CosmicLifeAI The 50% off code has expired now, but special promo codes are included inside the template sheets to give you discounts when you're ready to upgrade to a paid version.
Hi, I work as an EA and my client is interested in speaking with you about possibly progamming what she needs to be done for her business. She is curious how much a custom template would be? :)
When I change the priority of a task of a tab, such as the "waiting" tab, I ended up using a kludge to properly prioritize it: I moved it to the "completed" tab and then moved it back to the "waiting" tab (where it has been originally). Is there a more efficient way of sorting tasks by priority when I change a task's priority, yet do not move it to another tab?
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
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.
I just bought the pro version with the calendar and it already seems great! I really love the automatic doc generation. I was wondering if it is possible to filter all the tasks inside of the "waiting" "backlog" to-do" etc by project category? as i see is possible in the main kanban view. Thank you so much for the template. :)
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!
Is the task a "Google task" so it's on my google calendar with an option to have a reminder? If so is it possible to do it the other way round where I have my list of tasks in my "to do" and I can create "tasks" on my google calendar based off the due dates in the task list?
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 😉
This would appear to be exactly what I am looking for. I would need it for 3 different areas that I need to manage. With the paid version am I allowed/able to create more of the same template to use to keep my information separate? Like a "save as" for each of my areas of responsibilities? Or would I need to purchase a quantity of 3?
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 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.
@@JonasCap-v1m 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.
If I were to buy this, may I give copies of it to people with whom I work? To be clear: I'm not asking you for permission to resell your intellectual property. I have zero intent/desire to compete with you. However, under US copyright law (I live in the US), you own the copyright to the Google Apps Script code you created. Therefore, it would be illegal for me to redistribute your intellectual property without your express permission.
@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.
Does this work with google shared drives? 95% of my work includes google shared drives. Also, I do not want to clutter google shared drives with this management system google docs, sheets, etc. Does that happen? Thanks. I have purchased the system and am currently incorporating it.
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 Guys, this script is very helpful. I'll use it to order my job task, I already purchase it but, I need to know how can I add process sheets? This sample has 5 process steps, but I need at least 2 more. On the other hand, I want to connect this spreadsheet with Gmail, using GmailApp module on google scripts matching the column status with the labels I created in my gmail and add a step changing the email label from the spreadsheet when the status change. Do you have any recommendation for it?
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, I just bought the pro version to use for my business a few days ago. It’s been a great help to sort the different tasks out! I was wondering though, is it possible to add a new tab (a refund list) to the same sheet without messing up the existing tabs (by tabs, I’m referring to “taskboard”, “backlog”, etc)? Thank you for this amazing product!
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 👍
Hi! Thank sooo awesome! Thank you!! Just purchased. I would like to add an 'Assign' column so I can assign certain people to a task, and add a 'Notes' column, but I don't want to break the sheet. Is there a way I can do that? Thank you!
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 👍🏻
Here's a suggestion... add the ability to assign tasks to other people, and enable those other people to view tasks in a similar, yet different Google Sheet. After all, "No man is an island."
@@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).
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.
@@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?
@@spreadsheetwise I wanted to try the Basic or Pro To-do list before purchasing the Project Management Template/Calander integrated. However, I have not received the free basic to-do template after purchasing (0.00 Eur). Check below. Could you kindly help me by sending the to do template? PS: I also did not find the promo code for the discount of 50% or more for Project Management Template.
Hi @CosmicLifeAI The confirmation email includes a download link to a PDF containing this template's link, along with setup instructions, etc. The 50% off code has expired now, but special promo codes are inside the sheets to give you discounts when you're ready to upgrade to a paid version.
This is a godsend in a time when companies charge 20 euros per month for task management software. Instantly bought the pro version, thanks!
Thanks for the support 👍🏻
This is fantastic. Exactly what I need to gather my thoughts and ideas in one place. Easy to access on the go. Just purchased.
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 😉
Hi! This has saved me so much time! I wanted to find out how to change the "Category" label from "Project A" etc. Thanks!
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!
Thank you so much @yeimyfranco7625 you're very kind 🙏🏻 😊
Could you kindly suggest the promocode to get 50% or more discount? I am unable to get the discount you mentioned in the video. :)
Hi @CosmicLifeAI
The 50% off code has expired now, but special promo codes are included inside the template sheets to give you discounts when you're ready to upgrade to a paid version.
Hi, I work as an EA and my client is interested in speaking with you about possibly progamming what she needs to be done for her business. She is curious how much a custom template would be? :)
Hi @brittanynicolephotography
Thanks for reaching out, please drop me a message via the website so we can discuss your requirements. 👍🏻
When I change the priority of a task of a tab, such as the "waiting" tab, I ended up using a kludge to properly prioritize it: I moved it to the "completed" tab and then moved it back to the "waiting" tab (where it has been originally). Is there a more efficient way of sorting tasks by priority when I change a task's priority, yet do not move it to another tab?
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
Another question: how to I attached google docs/sheets links to the to do task item?
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.
How do i create these templates?
Hi @SreyasiChakravarty you can have a go at building this yourself, or I do have a bunch of ready made templates on my website.👍🏻
Is there a way to easily assign tasks to different people. I collaborate with a team of about 3-4 people
Sure, but you would need to consider the Project Management template here: bit.ly/project-management-template 😉
Is it possible to change the date format from UK to Canadian format? M/D/Y?
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 👍🏻
I just bought the pro version with the calendar and it already seems great! I really love the automatic doc generation. I was wondering if it is possible to filter all the tasks inside of the "waiting" "backlog" to-do" etc by project category? as i see is possible in the main kanban view. Thank you so much for the template. :)
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!
Is the task a "Google task" so it's on my google calendar with an option to have a reminder? If so is it possible to do it the other way round where I have my list of tasks in my "to do" and I can create "tasks" on my google calendar based off the due dates in the task list?
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 😉
Exactly what I was looking for. Thanks.
Thanks for the comment 👍🏻
This would appear to be exactly what I am looking for. I would need it for 3 different areas that I need to manage. With the paid version am I allowed/able to create more of the same template to use to keep my information separate? Like a "save as" for each of my areas of responsibilities? Or would I need to purchase a quantity of 3?
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.
@@JonasCap-v1m 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, thanks for yuor job, work well! When I was trying to add viewers the script failed to execute. Is it possible, in general, to add viewers?
Thanks!
Do you mean sharing the sheet with others?
If I were to buy this, may I give copies of it to people with whom I work? To be clear: I'm not asking you for permission to resell your intellectual property. I have zero intent/desire to compete with you. However, under US copyright law (I live in the US), you own the copyright to the Google Apps Script code you created. Therefore, it would be illegal for me to redistribute your intellectual property without your express permission.
@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.
Hi! This is amazing. I purchased the Pro but I was trying to tweak it a bit to add tabs per each team member and I couldn't. Could I get any guidance?
Hi there!
Thanks for the order. It would be best to contact us via the website for assistance on this. 👍
Does this work with google shared drives? 95% of my work includes google shared drives. Also, I do not want to clutter google shared drives with this management system google docs, sheets, etc. Does that happen? Thanks. I have purchased the system and am currently incorporating it.
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 Guys, this script is very helpful. I'll use it to order my job task, I already purchase it but, I need to know how can I add process sheets? This sample has 5 process steps, but I need at least 2 more. On the other hand, I want to connect this spreadsheet with Gmail, using GmailApp module on google scripts matching the column status with the labels I created in my gmail and add a step changing the email label from the spreadsheet when the status change. Do you have any recommendation for it?
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, I just bought the pro version to use for my business a few days ago. It’s been a great help to sort the different tasks out! I was wondering though, is it possible to add a new tab (a refund list) to the same sheet without messing up the existing tabs (by tabs, I’m referring to “taskboard”, “backlog”, etc)? Thank you for this amazing product!
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 👍
Hi! Thank sooo awesome! Thank you!! Just purchased. I would like to add an 'Assign' column so I can assign certain people to a task, and add a 'Notes' column, but I don't want to break the sheet. Is there a way I can do that? Thank you!
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 👍🏻
Thanks for making this! a super helpful tool
Thanks, it's comments like these that make it all worth while 😊
So clever, just purchased
Thanks! 😊
Thanks, going to give the Pro a shot, this looks like it could replace a monthly app payment for simple project management.
Thanks @JavierOropeza08 👍🏻
This is amazing! Make more videos!!
Thanks @micahmalloy, I really appreciate your comment, I’m glad you liked the vid 👍🏻
Here's a suggestion... add the ability to assign tasks to other people, and enable those other people to view tasks in a similar, yet different Google Sheet. After all, "No man is an island."
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).
Hi! I think this is a great Task Management Tracker. I would like to change the Titles of the Task Status. Would you be able to help with that?
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.
Thanks , my productivity just shot up
That's awesome to hear, thanks for the feedback 😉
This doesn't work. It doesn't move from different sheets.
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?
@@spreadsheetwise I wanted to try the Basic or Pro To-do list before purchasing the Project Management Template/Calander integrated.
However, I have not received the free basic to-do template after purchasing (0.00 Eur). Check below. Could you kindly help me by sending the to do template?
PS: I also did not find the promo code for the discount of 50% or more for Project Management Template.
Hi @CosmicLifeAI
The confirmation email includes a download link to a PDF containing this template's link, along with setup instructions, etc.
The 50% off code has expired now, but special promo codes are inside the sheets to give you discounts when you're ready to upgrade to a paid version.