Checkbox Count as Progress Bar

Topic Labels: Formulas
Jump to Solution
3163 10
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


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). 


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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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