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.

Checkbox Count as Progress Bar

Topic Labels: Formulas
Solved
Jump to Solution
6013 11
cancel
Showing results for 
Search instead for 
Did you mean: 
alebarbosacial
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey! 

I have 3 checkbox fields that indicate the completion of a task. I want to show completion of the tasks using the newly released progress bar on the Percent tab, but without having to manually type in the thirds (1/3, 2/3, 3/3). 

alebarbosacial_3-1686235338094.png

If I use a formula to sum up the checks as a third, then use another formula to make it into a percent, I still won't be able to get the bar since the formula field does not come with that feature. How do I get that % into the percent field without having to create an automation? Is that the only way, or is there an easier/simpler way to go about this?

Thanks in advance 🙂 

 

 

11 Replies 11
E77en
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes, there is! This is what I used for 5 checkboxes in different fields: 

SUM(
IF({Checkbox1}, 1, 0),
IF({Checkbox2}, 1, 0),
IF({Checkbox3}, 1, 0),
IF({Checkbox4}, 1, 0),
IF({Checkbox5}, 1, 0)
) / 5

 

 
Jen_Pennington
5 - Automation Enthusiast
5 - Automation Enthusiast

E77en this solution was the best fix for me. And the simplest. Thank you.