Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Progress Bar 0% issue

Topic Labels: Formulas
Solved
Jump to Solution
1026 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Karola_Martinez
6 - Interface Innovator
6 - Interface Innovator

Hi guys! I was wondering if you could help me figure out why I get those texts in the progress bar field? How do I get the bar to appear at 0%?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right?

Screenshot 2024-08-16 at 1.58.12 PM.png

IF(
  {Total tasks},
  {Pending tasks} / {Total tasks}
)

See Solution in Thread

3 Replies 3

Depends on what your formula for your percentage is. It'll run into issues calculating dividing by zero.

A workaround would be to choose one of the options to display as 1 anytime a 0 is shown. The formula will differ depending on how your original percentage is calculated.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right?

Screenshot 2024-08-16 at 1.58.12 PM.png

IF(
  {Total tasks},
  {Pending tasks} / {Total tasks}
)
Karola_Martinez
6 - Interface Innovator
6 - Interface Innovator

Amazing!!! Thaks a lot!!! 🙏