✨Download free template?✨ For the finished version of the template, you can grab it here. Make sure to add code: TASK100 during checkout to get it for free. We are doing this to prevent bots from downloading our entire template library. Although it’s free, we would greatly appreciate any support so that we can continue doing this. ❤ theorganizednotebook.com/project-task-manager-bwm-progress-bars/
Thank you SO much for explaining each part (relations, formula, linked view) in terms we can follow/understand. Many other Creators go too fast and it's easy to give up on Notion. You've given this newbie Notion user hope!
Thank you so much for your kind words! We are glad that our video was helpful and we hope to continue creating more useful tutorials and videos about Notion!
Amazing tutorial @theorganizednotebook.Thanks for putting it together! When we archive a Project (as per your tut), they do indeed disappear from the Gallery View. However, the tasks associated with that project will continue to be displayed in the Completed Tasks section (on Board view at stage "Completed"). Is there a way to hide/archive these Completed Tasks from the Board view? I'd like to see completed tasks only coming from Active (i.e.: not archived) projects. Thank you!!
Thank you so much for following our tutorial and most importantly, for sharing your question with us! The easiest way is to do these below steps: 1. Go to Task database -> Create a rollup type (you can name this Archive Status -> Choose relation: Projects -> Property: Archive -> Calculate: Show Original 2. Go to Filter -> Select rollup "Archive Status" -> Choose "Unchecked" (this means the database will only show task from ACTIVE PROJECTS. So when you archive a project, all relevant tasks from that project will not be displayed in the current view)
Wonderful Tutorial! I have a question regarding the progress bar. How can I round up the numbers so the percentage is not 66.6666666666% for 3 done tasks and 1 that's not? Thank you very much!
Thank you for watching! We're glad to hear it's helpful. If you need to round we suggest this formula: round(prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()*100)/100 unfortunately the round function only rounds to integers so you have to multiply by 100 and then divide again!
Thank you for watching! If you need to assign the same tasks to every new project, one way to do this would be to add an automation to add new database task pages with a relation to that project, for every new project created. Hope this helps!
@@theorganizednotebook im super new to notion. so if you know of anywhere I can learn to do what you just said that would be fantastic. either one of your own uploads or somewhere else. I think it's just not possible. I have been searching for well over a week to try to see how it might be done.
I don't have a specific video tutorial on the channel covering this topic! But this is actually a good idea for a future tutorial. Stay tuned! In the meantime, if you're new to Notion's database automations, you can check out the guide here: www.notion.so/help/database-automations
Hi Thank you for watching! If students would like to incorporate their school work you could consider adding embedded documents into the projects/tasks page or adding a property for files & media! Hope this helps!
Thank you for the tutorial. Trying to get my head round what Notion can do and this one was perfect for my needs. One question: The call out box at the top with the databases: Projects & Tasks, is there a way to put these somewhere else less visible other than dragging them to the bottom of the page? The cover at the top already takes up so much room and I would like to see the projects and some of the tasks straight away without having the scroll. Plus it would make it all look a bit neater.
Hi, thank you so much for watching our video. To arrange the database, we highly recommend you watching our latest video on designing a navigation bar here: ruclips.net/video/0s5Ks93old4/видео.html
Hello, this is so helpful, I have a question, in every project I have over 50 tasks so I cannot make a project for every task, instead, I want to write the to-do list of the project (lessons to study) as checkboxes, and put a formula to count how many are checked (done) to have a progress bar, I could not find the right way/formula, your help is so much needed and appreciated, thank you so much!
Awesome video! Question, I have applied same theory for Archiving on tasks (works great) but I have the tasks listed on my project page still showing all tasks including archived (no option to filter) do you have a work around so the achived tasks dont show on the project page? Thanks in Advance. Brad.
Thank you for watching our video! If you'd like to further filter based on whether or not the task is archived you should be able to add that as a filter option in the database. Just click filter and check for Archived unchecked. If you need to update the formula for the progress bar it gets a bit more complex. You should add prop("Tasks").filter((current.prop("Archive?") != true) and current.prop("Status") != "Done").length()/prop("Tasks").filter(current.prop("Archive?") != true).length() the following formula is if we assume that "Archive?" is a checkbox property and checking it means it goes to archive. Hope this helps!
Thank you for watching! If you want to add it to your home area in Notion, you can do so by going to the database settings and add the functionality to see your tasks in Home. We cover this in more detail here: ruclips.net/video/HBBMu9PCWHI/видео.html
Is there a reason why certain things aren’t showing up in Notion anymore? I tried following along with this video and there is no projects property anymore to make the status bars.
Thank you for watching our video! It should still be working the same, although Notion has rolled out a few updates recently! Could you check the formula in the project database that it is: prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length() If you'd like to see a sample of the completed template it is also available here: theorganizednotebook.gumroad.com/l/project-task-manager-bwm-progress-bars Make sure to enter code TASK100 to get it for free! If you need further help, please contact us at organizednotebook.info@gmail.com We'd love to help you out!
Thank you for watching! We're glad to hear it's helpful. If you need to round we suggest this formula: round(prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()*100)/100 . Unfortunately, the round function only rounds to integers so you have to multiply by 100 and then divide again! Hope this helps :)
I wrote the exact same formula but when i have for example 8 tasks and one is done it only shows 0.125/100 Done wich is like tiny it should be 12.5/100
Thank you for watching! How about trying it again with this formula below? (note that the round function only rounds to integers so you have to multiply by 100 and then divide again) round(prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()*100)/100
Thank you so much for watching our video! A checkbox indicates that it is likely a true or false scenario that you've created inside of the formula. Could you send us the exact formula you wrote to organizednotebook.info@gmail.com with a screenshot and we'd be happy to help you out!
Hello, thank you for letting us know. Very likely it is because of the link we posted on RUclips Description got shortened by RUclips. Here is the link: theorganizednotebook.com/project-task-manager-bwm-progress-bars/ Hope you enjoy our template!
Hi! Thank you for watching our video, if you go to the link to download it says the following: "Make sure to add code: TASK100 during checkout to get it for free." Please use the code during checkout to get it for free! We had some issues with bots downloading our entire library that we spend hours on and our templates being resold. Hope you understand ❤️
✨Download free template?✨
For the finished version of the template, you can grab it here. Make sure to add code: TASK100 during checkout to get it for free. We are doing this to prevent bots from downloading our entire template library. Although it’s free, we would greatly appreciate any support so that we can continue doing this. ❤
theorganizednotebook.com/project-task-manager-bwm-progress-bars/
Thank you SO much for explaining each part (relations, formula, linked view) in terms we can follow/understand. Many other Creators go too fast and it's easy to give up on Notion. You've given this newbie Notion user hope!
So glad to hear you found our video helpful! Please stay tuned for more
I've been using Notion for many years, although only for light things. After watching your video, I understand its full potential. Thank you.
Thank you so much for your kind words! We are glad that our video was helpful and we hope to continue creating more useful tutorials and videos about Notion!
This is the best notion tutorial I've ever watched!
Thank you so much for your compliment!
Thank you so much for this awesome tutorial and the file. 💜
Thank you so much for watching! I'm glad to hear that it was helpful. Stay tuned for more!
Thank you so much, this really helped me!!!
Thank you for watching! I'm glad it is useful!
Best video on making a progress bar with formulas. thank you!
Thank you for watching and your kind words! We're glad it was helpful, stay tuned for more!
I don't know how to thank you for this tutrial ,,, I'm grateful for you
Thank you so much for watching! We're glad that the tutorial was helpful for you, stay tuned for more!
Wow, this was wonderful. Thank you
Thank you so much for watching and glad to hear it was helpful!
The best explanation. Thank you so much!
Thank you for watching our video! We're glad it was helpful, stay tuned for more 😊
I appreciate the steps! Very useful workflow, thanks!
Thank you for watching! Glad to hear it was useful, stay tuned for more!
Thank you so much for this!
Thank you so much for watching! We're glad that this video was helpful!
Great tutorial, very detailed and practical guides. Helped me a lot in managing my own workspace. Have a nice day!
So glad to hear you found our tutorial helpful! Please stay tuned for more :)
Really good, thank you!
Thank you for watching! Glad to hear it was helpful!
This is so helpful. I've been finding a video like this and it really helped me. Thank you ^^
Glad it helped! Hope you enjoy the template too! ♥️
That was great!!!! Thank you
Thank you so much for watching! We're glad it was helpful!
Thanks! It's really helpful
Glad to hear it was helpful! Stay tuned for more 😊
Awesome video. Really helpful. Thank you 😊
Thank you so much for watching!
Very useful. Thanks
Thank you for watching our video! Glad that it was useful, stay tuned for more! 😊
Amazing tutorial @theorganizednotebook.Thanks for putting it together! When we archive a Project (as per your tut), they do indeed disappear from the Gallery View. However, the tasks associated with that project will continue to be displayed in the Completed Tasks section (on Board view at stage "Completed"). Is there a way to hide/archive these Completed Tasks from the Board view? I'd like to see completed tasks only coming from Active (i.e.: not archived) projects. Thank you!!
Thank you so much for following our tutorial and most importantly, for sharing your question with us! The easiest way is to do these below steps:
1. Go to Task database -> Create a rollup type (you can name this Archive Status -> Choose relation: Projects -> Property: Archive -> Calculate: Show Original
2. Go to Filter -> Select rollup "Archive Status" -> Choose "Unchecked"
(this means the database will only show task from ACTIVE PROJECTS. So when you archive a project, all relevant tasks from that project will not be displayed in the current view)
Thank you so much for letting us know a great feature. Please let us know if you need any more help!
✨Download our template here: theorganizednotebook.com/project-task-manager-bwm-progress-bars/
Wonderful Tutorial! I have a question regarding the progress bar. How can I round up the numbers so the percentage is not 66.6666666666% for 3 done tasks and 1 that's not? Thank you very much!
Thank you for watching! We're glad to hear it's helpful. If you need to round we suggest this formula: round(prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()*100)/100 unfortunately the round function only rounds to integers so you have to multiply by 100 and then divide again!
Thank you. I will use your template.
Thank you! Hope you enjoy it ♥️
All well and good. I am trying to figure out a way of assigning the same tasks to every new project
Thank you for watching! If you need to assign the same tasks to every new project, one way to do this would be to add an automation to add new database task pages with a relation to that project, for every new project created. Hope this helps!
@@theorganizednotebook im super new to notion. so if you know of anywhere I can learn to do what you just said that would be fantastic. either one of your own uploads or somewhere else. I think it's just not possible. I have been searching for well over a week to try to see how it might be done.
I don't have a specific video tutorial on the channel covering this topic! But this is actually a good idea for a future tutorial. Stay tuned! In the meantime, if you're new to Notion's database automations, you can check out the guide here: www.notion.so/help/database-automations
the template is great how can students incorporate their school work into it do you have a video about that?
Hi Thank you for watching! If students would like to incorporate their school work you could consider adding embedded documents into the projects/tasks page or adding a property for files & media! Hope this helps!
Thank you
You're very welcome! We're glad that the video was helpful!
Thank you for the tutorial. Trying to get my head round what Notion can do and this one was perfect for my needs.
One question: The call out box at the top with the databases: Projects & Tasks, is there a way to put these somewhere else less visible other than dragging them to the bottom of the page? The cover at the top already takes up so much room and I would like to see the projects and some of the tasks straight away without having the scroll. Plus it would make it all look a bit neater.
Hi, thank you so much for watching our video. To arrange the database, we highly recommend you watching our latest video on designing a navigation bar here: ruclips.net/video/0s5Ks93old4/видео.html
Hello, this is so helpful, I have a question, in every project I have over 50 tasks so I cannot make a project for every task, instead, I want to write the to-do list of the project (lessons to study) as checkboxes, and put a formula to count how many are checked (done) to have a progress bar, I could not find the right way/formula, your help is so much needed and appreciated, thank you so much!
So glad to hear you find our tutorial video helpful! Please stay tuned for more :)
Awesome video! Question, I have applied same theory for Archiving on tasks (works great) but I have the tasks listed on my project page still showing all tasks including archived (no option to filter) do you have a work around so the achived tasks dont show on the project page? Thanks in Advance. Brad.
Thank you for watching our video! If you'd like to further filter based on whether or not the task is archived you should be able to add that as a filter option in the database. Just click filter and check for Archived unchecked. If you need to update the formula for the progress bar it gets a bit more complex. You should add prop("Tasks").filter((current.prop("Archive?") != true) and current.prop("Status") != "Done").length()/prop("Tasks").filter(current.prop("Archive?") != true).length() the following formula is if we assume that "Archive?" is a checkbox property and checking it means it goes to archive. Hope this helps!
Thank you. I have been watching your other videos, they are great also!@@theorganizednotebook
So glad to hear you found our tutorial videos helpful :)
Hi! How can I add my tasks to my home space calendar? Thank you :)
Thank you for watching! If you want to add it to your home area in Notion, you can do so by going to the database settings and add the functionality to see your tasks in Home. We cover this in more detail here: ruclips.net/video/HBBMu9PCWHI/видео.html
Is there a reason why certain things aren’t showing up in Notion anymore? I tried following along with this video and there is no projects property anymore to make the status bars.
Thank you for watching our video! It should still be working the same, although Notion has rolled out a few updates recently!
Could you check the formula in the project database that it is: prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()
If you'd like to see a sample of the completed template it is also available here: theorganizednotebook.gumroad.com/l/project-task-manager-bwm-progress-bars Make sure to enter code TASK100 to get it for free!
If you need further help, please contact us at organizednotebook.info@gmail.com We'd love to help you out!
How do you get the progress bar to give whole numbers rather than 33.3333333%? which is what I'm getting. Thanks
Thank you for watching! We're glad to hear it's helpful.
If you need to round we suggest this formula: round(prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()*100)/100 . Unfortunately, the round function only rounds to integers so you have to multiply by 100 and then divide again! Hope this helps :)
@@theorganizednotebook thank you
@@theorganizednotebook, hi it's doesn't work on me💔
@enricoponce5733 , oh no, we missed your comment. Could you let us know which issue you encounter? We are happy to help you!
I wrote the exact same formula but when i have for example 8 tasks and one is done it only shows 0.125/100 Done wich is like tiny it should be 12.5/100
Thank you for watching! How about trying it again with this formula below? (note that the round function only rounds to integers so you have to multiply by 100 and then divide again)
round(prop("Tasks").filter(current.prop("Status") == "Done").length()/prop("Tasks").length()*100)/100
Thanks yes of course just multiply by a 100 but i still am wondering why it dosnt work automaticly
Hi, it might be probably related to Notion formula coding system. But we hope our video helps you! :)
When I write formula for progress bar, a checkbox appears
Thank you so much for watching our video! A checkbox indicates that it is likely a true or false scenario that you've created inside of the formula. Could you send us the exact formula you wrote to organizednotebook.info@gmail.com with a screenshot and we'd be happy to help you out!
That is a very nice tutorial, good job! But the download to the free template is not working.... :(
NET::ERR_CERT_AUTHORITY_INVALID
Hello, thank you for letting us know. Very likely it is because of the link we posted on RUclips Description got shortened by RUclips. Here is the link: theorganizednotebook.com/project-task-manager-bwm-progress-bars/
Hope you enjoy our template!
It says "download free template" but when you go to download it requires a $2 minimum purchase. That's a scammy practice.
Hi! Thank you for watching our video, if you go to the link to download it says the following: "Make sure to add code: TASK100 during checkout to get it for free." Please use the code during checkout to get it for free! We had some issues with bots downloading our entire library that we spend hours on and our templates being resold. Hope you understand ❤️