Skip to main content

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 🙂 

 

 

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

 

 

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

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!

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.

 

 

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? 

 

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? 🙂 

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

Thanks for your help, everyone! It worked 🙂 

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?

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

 

 

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


Terms & Conditions