✨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!
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!
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 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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0s5Ks93old4.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!
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!
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 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 :)
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 RU-vid Description got shortened by RU-vid. 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 ❤️