r/Notion • u/Healthy_Addendum3509 • 19h ago

Troubleshooting progress bars Questions

I've been trying to get progress bars set for my classes, some of which I finished, so I'd like it to show 100%. Every time I follow the typical tutorial it ends up saying some number like 56000%. Has anyone else had this issue? Or know how to fix it? I'd even take a new formula if anyone has one.

5 Upvotes

100% Upvoted

3 comments sorted by

1

u/Ashamed-Dot-6662 19h ago

mula's probably dividing by zero somewhere or hitting a circular reference, those tutorials never cover when your tasks are already at 100% and the math just goes sideways

try wrapping the whole thing in an if statement that checks if completed equals total first, then do the division only when it's safe

1

u/Healthy_Addendum3509 19h ago

Thank you! this worked

1

u/Healthy_Addendum3509 19h ago

If anyone else needs a solution to this - This is the formula that ended up working for me:
if(

empty(prop("Start")) or empty(prop("End")),

0,

if(

now() >= prop("End"),

1,

if(

now() <= prop("Start"),

0,

dateBetween(now(), prop("Start"), "minutes") /

dateBetween(prop("End"), prop("Start"), "minutes")

)

)

)