Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 08, 2023 07:46 AM
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 🙂
Solved! Go to Solution.
Jun 08, 2023 08:00 AM
Hello. You can use the new status bar on a formula field. Click on the formatting tab in your field properties.
Jun 08, 2023 08:00 AM
Hello. You can use the new status bar on a formula field. Click on the formatting tab in your field properties.
Jun 08, 2023 08:01 AM
Hmm, this seems to work fine for me. Have a look at this base?
Jun 08, 2023 08:37 AM
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!
Jun 08, 2023 08:52 AM
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.
Jun 08, 2023 09:40 AM
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?
Jun 08, 2023 09:41 AM
Hey! Can you share the formula you used for this, please? 🙂
Jun 08, 2023 10:28 AM
Here's a simple formula. It assumes the person checking the box, checks them in order.
Jun 08, 2023 11:55 AM
Thanks for your help, everyone! It worked 🙂
Jul 12, 2023 10:03 AM
Is there a way to do this without the boxes needing to be checked in order?