I wish there was a way to show progress bar/percentages without having to update numbers manually. For example, if you have a checklist, and you tick 8 out of 10 checklist items, it automatically shows you 80% complete, rather than in a tabular format whereby you gotta change the numbers daily for accurate results.
you can use 'unaryPlus' function in a formula. each ticked checkbox will return '1'. from there you can calculate percentage based on however many checkboxes you have. credit to RedGregory for teaching me that.
I would love to have different colors for my grades tracks. Like, 0~60% progress bar red, 60%~80% yellow and 80%+ green. I tried so hard different formulas, but I haven't had success. :(
maybe you can have three different bars with red, green and yellow. and have three different grade tracks. then set all three bars to be hidden if empty, and use a formula like this: "if progress bigger than 0 and smaller than 60, progress, else 0" "if progress bigger than or equal to 60 and smaller than 80, progress, else 0" "if progress bigger than or equal to 80, progress, else 0" visually, this will change the color based on the progression. but from a technical standpoint, you have three bars, and the two you don't want just stay hidden.
I have a database for games I’m playing. Each game page I copied over the list of levels each game has. When I finish that level, I check the box. How can I make this become a progress bar? Can’t wrap my head around it.
The Target would be the Total # Levels and current would be # Completed Levels. Use a formula to calculate the % Completed Levels (progress) and then display that with a progress indicator. Ideally you’d have a games database and a related levels database and roll up those totals from levels to games, then do the progress calculation for each game. But you could manually enter those numbers too or use a formula to count the number of checked checkboxes (the latter would probably require some manual maintenance though). I hope that helps!
@@aNotioneer I’m hoping that I don’t have to turn the levels into a database. And that I can get my main gaming database to calculate how many boxes are checked inside of that title’s page
Each to their own of course! Lots of medium sized companies use Notion too though, I often help people switch from Jira to Notion because they want a tool that they can customise more
I tried it and I will stick with my huge formula. Cause the way notion designed it, it doesn’t catch the eye, I can’t see the difference between them so clearly
What I wished so BADLY on my progress bar is to show how many tasks/episodes you are in from the total amount. I have seen a layout like that but the person has not released a template of it as the formula is very complex. Per show/anime it would show the progress bar like so; //////...... 10/40 10 of the 40 total episodes have been watched, I've been meaning to have that shown on mine but the formula's are just so complicated to work for each different page of a show/anime that I gave up after trying for hours on end to make it work. This feature is a nice step in the right direction, it still kinda sucks how I have to do it manually regarding 'target / result' amount as there is no way to have the property differ per page. Trello shows the 10/40 number just fine, granted without a progress bar, but that is a detail I would love to have shown on Notion.
Unfortunately the progress bar feature's not very customisable but Ben Something's progress bar builder is the best tool for creating custom progress bars - it sounds like they'd do what Kyjana described. bensomething.notion.site/Progress-Bar-Builder-aaaffe0c64594e42a36c6410b37cf129
What is divide by option in setting? I think progress bar in number property is too small because of it. Try change it to see if that makes any difference.
I'm not sure what you mean about the progress bar being too small? I added a bonus tip in the Notion page that I've linked to in the description about the divide by option.
@@aNotioneer In exact 3:45 you talk about numbers which are not percentage but numbers which are not percentage have additional feature called divide by. You can set percentage which is always divide by 100 or number which you can manually divide by any number like 1/4 or 10/25 etc. and then use it as progress bar.
@@lukajeliciclux3074 Thanks for pointing that out, it took me some time to spot that so I added a bonus tip about it in the Notion page in the description 🙌
Sorry. But nothing is working for me. It keep saying smth is undefined and such. ‘Round’ and 100s are red and unlike your properties being green mines are gray.
Thanks for the video, it's really useful; I have a question: is there a way to transfer the progress bar as a propriety of a page? Eg I have a to-do list of books that I have to read, and I would like to add as a propriety that displays only the progress bar of the pages that I have studied. Is there a way? Thanks in advance
Yes, you can create a formula property which only calculates your progress once you start recording your progress so something like if(prop("Pages Read") > 0, prop("Pages Read") / prop("Total Pages"), toNum("")) You’ll need to format the output as a % and then display it as a progress bar. Hope that helps!
I'm struggling to make this work with a rollup of the new status feature. I have a database of projects and another of tasks. I'm rolling up the tasks on the projects db to see the progress of the project. I'm able to get the fraction or percentage of what is complete but when this get's translated into the progress bar the percentage get's misrepresented. Any idea how to fix this?
It's definitely possible to set that up but it's difficult to guess what the issue is there, without seeing what you've done. You can see how I've configured that here, for example www.notion.so/anotioneer/a53bf00ee83d4f56a9d64273a3fe0ddc?v=46def4948cd64118bbf1991a95c85886
I just wish they'd implement a way to make this a beautiful, large graphic, instead of one puny field in a table... just another example of a startup run by tech bros that have no idea of what regular people want.
I literally just implemented a weird progress bar formula this morning. Can't wait for the actual notion update!
I wish there was a way to show progress bar/percentages without having to update numbers manually. For example, if you have a checklist, and you tick 8 out of 10 checklist items, it automatically shows you 80% complete, rather than in a tabular format whereby you gotta change the numbers daily for accurate results.
You can set this up if you use a formula property to calculate the % of completed checkboxes and then display that % as a progress bar 🙌
you can use 'unaryPlus' function in a formula. each ticked checkbox will return '1'. from there you can calculate percentage based on however many checkboxes you have. credit to RedGregory for teaching me that.
@@asherwood2350 can we get an example of this?
round(divide(prop("Price"), prop("Weight")) * 100) / 100
I would love to have different colors for my grades tracks. Like, 0~60% progress bar red, 60%~80% yellow and 80%+ green. I tried so hard different formulas, but I haven't had success. :(
maybe you can have three different bars with red, green and yellow. and have three different grade tracks. then set all three bars to be hidden if empty, and use a formula like this:
"if progress bigger than 0 and smaller than 60, progress, else 0"
"if progress bigger than or equal to 60 and smaller than 80, progress, else 0"
"if progress bigger than or equal to 80, progress, else 0"
visually, this will change the color based on the progression. but from a technical standpoint, you have three bars, and the two you don't want just stay hidden.
Nice, I want colored progress bar you know like, green is it's satisfying or yellow if it's medium.
I have a database for games I’m playing. Each game page I copied over the list of levels each game has. When I finish that level, I check the box. How can I make this become a progress bar? Can’t wrap my head around it.
The Target would be the Total # Levels and current would be # Completed Levels. Use a formula to calculate the % Completed Levels (progress) and then display that with a progress indicator.
Ideally you’d have a games database and a related levels database and roll up those totals from levels to games, then do the progress calculation for each game. But you could manually enter those numbers too or use a formula to count the number of checked checkboxes (the latter would probably require some manual maintenance though).
I hope that helps!
@@aNotioneer I’m hoping that I don’t have to turn the levels into a database. And that I can get my main gaming database to calculate how many boxes are checked inside of that title’s page
Notion is more fit for tiny startups, entrepreneurs or personal use. So many features are manually and automation is needed. Moving over to JIRA!
Each to their own of course! Lots of medium sized companies use Notion too though, I often help people switch from Jira to Notion because they want a tool that they can customise more
I tried it and I will stick with my huge formula. Cause the way notion designed it, it doesn’t catch the eye, I can’t see the difference between them so clearly
What I wished so BADLY on my progress bar is to show how many tasks/episodes you are in from the total amount. I have seen a layout like that but the person has not released a template of it as the formula is very complex.
Per show/anime it would show the progress bar like so; //////...... 10/40
10 of the 40 total episodes have been watched, I've been meaning to have that shown on mine but the formula's are just so complicated to work for each different page of a show/anime that I gave up after trying for hours on end to make it work.
This feature is a nice step in the right direction, it still kinda sucks how I have to do it manually regarding 'target / result' amount as there is no way to have the property differ per page. Trello shows the 10/40 number just fine, granted without a progress bar, but that is a detail I would love to have shown on Notion.
I'm looking for this too!
Unfortunately the progress bar feature's not very customisable but Ben Something's progress bar builder is the best tool for creating custom progress bars - it sounds like they'd do what Kyjana described. bensomething.notion.site/Progress-Bar-Builder-aaaffe0c64594e42a36c6410b37cf129
I’ve seen tho that you can have counters in Notion. Maybe you already knew that, but maybe that could help out with your wish?
What is divide by option in setting? I think progress bar in number property is too small because of it. Try change it to see if that makes any difference.
I'm not sure what you mean about the progress bar being too small? I added a bonus tip in the Notion page that I've linked to in the description about the divide by option.
@@aNotioneer In exact 3:45 you talk about numbers which are not percentage but numbers which are not percentage have additional feature called divide by. You can set percentage which is always divide by 100 or number which you can manually divide by any number like 1/4 or 10/25 etc. and then use it as progress bar.
@@lukajeliciclux3074 Thanks for pointing that out, it took me some time to spot that so I added a bonus tip about it in the Notion page in the description 🙌
Can you get a progress bar for the whole table rather than for just that row??
You'd need to rollup your values to a page in another database in order to see that.
Sorry. But nothing is working for me. It keep saying smth is undefined and such. ‘Round’ and 100s are red and unlike your properties being green mines are gray.
Thanks for the video, it's really useful; I have a question: is there a way to transfer the progress bar as a propriety of a page? Eg I have a to-do list of books that I have to read, and I would like to add as a propriety that displays only the progress bar of the pages that I have studied. Is there a way? Thanks in advance
Yes, you can create a formula property which only calculates your progress once you start recording your progress so something like
if(prop("Pages Read") > 0, prop("Pages Read") / prop("Total Pages"), toNum(""))
You’ll need to format the output as a % and then display it as a progress bar. Hope that helps!
I'm struggling to make this work with a rollup of the new status feature. I have a database of projects and another of tasks. I'm rolling up the tasks on the projects db to see the progress of the project. I'm able to get the fraction or percentage of what is complete but when this get's translated into the progress bar the percentage get's misrepresented. Any idea how to fix this?
It's definitely possible to set that up but it's difficult to guess what the issue is there, without seeing what you've done. You can see how I've configured that here, for example www.notion.so/anotioneer/a53bf00ee83d4f56a9d64273a3fe0ddc?v=46def4948cd64118bbf1991a95c85886
The formula doesn't work at all for me. I did everything the exact same except did 100 and 40 and it gave me 3%...
Did you format the output of the formula as a percentage? 😉
I just wish they'd implement a way to make this a beautiful, large graphic, instead of one puny field in a table... just another example of a startup run by tech bros that have no idea of what regular people want.
thanks, this video really helped! How do you make the progress bar show up in gallery view? Is that possible, too?
You’re welcome! Yes, you can display progress bars in the gallery view. Just switch it on from the view’s properties settings
Hey, may I ask what sidebar that is with windows?
I’m using the beta version of macOS Ventura there :)
I don't get that feature, do you know why please ?
Neither my Mac or ChromeOS (web) version have the update either. Not sure how they roll updates out.
It looks like they're doing a staggered rollout, hopefully everyone will have it by the end of the day 🤞
@@aNotioneer Do they not realise that humans lack any sort of patience these days? :)
Haha ikr!
شكرا
its not morning for me bro
The daily tasks will be different, if you use this progress bar, every time you add a task, all days will automatically add that task.
At this pt notion is like Apple. All other docs have done it and then it's "hooray!" when Notion does it much later. smh. I'll check it out though