Help

Re: Checkbox Count as Progress Bar

Solved
Jump to Solution
485 0
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 🙂 

 

 

10 Replies 10
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