Skip to main content
Solved

Checkbox Count as Progress Bar

A
Forum|alt.badge.img+2

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

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 🙂 

 

 

Best answer by tgretencord

Hello. You can use the new status bar on a formula field. Click on the formatting tab in your field properties. 

 

 

View original
Did this topic help you find an answer to your question?

11 replies

T
Forum|alt.badge.img+3
  • tgretencord
  • New Participant
  • 3 replies
  • Answer
  • June 8, 2023

Hello. You can use the new status bar on a formula field. Click on the formatting tab in your field properties. 

 

 

S
A
2 people like this
  • S
    Sho
  • A
    alebarbosacial
TheTimeSavingCo
Forum|alt.badge.img+28

Hmm, this seems to work fine for me.  Have a look at this base?

Adam, Consultant @ thetimesaving.company
A
1 person likes this
  • A
    alebarbosacial
A
Forum|alt.badge.img+2

Hi @tgretencord 

Thank you for your help. I didn't know this was possible, awesome!

@TheTimeSavingCo can you share please the formula you used? 

Thanks!

T
Forum|alt.badge.img+3
  • tgretencord
  • New Participant
  • 3 replies
  • June 8, 2023
alebarbosacial wrote:

Hi @tgretencord 

Thank you for your help. I didn't know this was possible, awesome!

@TheTimeSavingCo can you share please the formula you used? 

Thanks!


alebarbosacial,

I have subtasks on some tasks and wanted to count them and track the completion. I built my subtasks by following the directions given in this video. https://www.youtube.com/watch?v=tTa5rwgOMwY

Here's my formula, which is a math formula of two formulated fields, which came from this video.

 

 

A
Forum|alt.badge.img+2
tgretencord wrote:

alebarbosacial,

I have subtasks on some tasks and wanted to count them and track the completion. I built my subtasks by following the directions given in this video. https://www.youtube.com/watch?v=tTa5rwgOMwY

Here's my formula, which is a math formula of two formulated fields, which came from this video.

 

 


Hey! 

This is a very helpful video, however, I have 100+ records that needs those three completion indicators and the video is specific to checkboxes in a large text field. I want to avoid copy and pasting that text in all of them & new ones that are created. 

I can't seem to find the best formula that works for what I need, which is to provide a completion percentage based on the 3 check mark fields I have. I feel like there is a simple way to do this, but haven't found the correct one. Is this something you can help with? 

 

A
Forum|alt.badge.img+2
TheTimeSavingCo wrote:

Hmm, this seems to work fine for me.  Have a look at this base?


Hey! Can you share the formula you used for this, please? 🙂 

T
Forum|alt.badge.img+3
  • tgretencord
  • New Participant
  • 3 replies
  • June 8, 2023
alebarbosacial wrote:

Hey! Can you share the formula you used for this, please? 🙂 


Here's a simple formula. It assumes the person checking the box, checks them in order. 

 

IF({done 3} = '1', 1, 
   IF({done 2} = '1', .66,
      IF({done 1} = '1', .33)))
A
1 person likes this
  • A
    alebarbosacial
A
Forum|alt.badge.img+2

Thanks for your help, everyone! It worked 🙂 

J
Forum|alt.badge.img+1
  • jsinger
  • New Participant
  • 1 reply
  • July 12, 2023
tgretencord wrote:

Here's a simple formula. It assumes the person checking the box, checks them in order. 

 

IF({done 3} = '1', 1, 
   IF({done 2} = '1', .66,
      IF({done 1} = '1', .33)))

Is there a way to do this without the boxes needing to be checked in order?

E
1 person likes this
  • E
    E77en
E
Forum|alt.badge.img+3
  • E77en
  • New Participant
  • 2 replies
  • January 14, 2024
jsinger wrote:

Is there a way to do this without the boxes needing to be checked in order?


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

 

 
J
Forum|alt.badge.img+5
  • Jen_Pennington
  • Participating Frequently
  • 7 replies
  • December 9, 2024
E77en wrote:

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

 

 

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

Reply


Most helpful members this week

Terms & Conditions