✨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 your kind words! We are glad that our video was helpful and we hope to continue creating more useful tutorials and videos about Notion!
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!
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!
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)
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!
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!
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: th-cam.com/video/0s5Ks93old4/w-d-xo.html
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: th-cam.com/video/HBBMu9PCWHI/w-d-xo.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 TH-cam Description got shortened by TH-cam. 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/
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!
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 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!
This is the best notion tutorial I've ever watched!
Thank you so much for your compliment!
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!
Wow, this was wonderful. Thank you
Thank you so much for watching and glad to hear it was helpful!
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!
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!
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 :)
I appreciate the steps! Very useful workflow, thanks!
Thank you for watching! Glad to hear it was useful, stay tuned for more!
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!
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 :)
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! ♥️
The best explanation. Thank you so much!
Thank you for watching our video! We're glad it was helpful, stay tuned for more 😊
Thank you so much for this!
Thank you so much for watching! We're glad that this 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: th-cam.com/video/0s5Ks93old4/w-d-xo.html
That was great!!!! Thank you
Thank you so much for watching! We're glad it was helpful!
Really good, thank you!
Thank you for watching! Glad to hear it was helpful!
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! 😊
Thanks! It's really helpful
Glad to hear it was helpful! 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 :)
Thank you
You're very welcome! We're glad that the video was 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: th-cam.com/video/HBBMu9PCWHI/w-d-xo.html
Thank you. I will use your template.
Thank you! Hope you enjoy it ♥️
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!
✨Download our template here: theorganizednotebook.com/project-task-manager-bwm-progress-bars/
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 TH-cam Description got shortened by TH-cam. 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 ❤️