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.