Skip to main content

Formula HELP: Percentage of checked boxes in cell

  • April 6, 2023
  • 2 replies
  • 19 views

Forum|alt.badge.img

Hi Guys, 

I'm working with a project tracker template which has tick boxes for subtasks in one cell. I want to create a column which can calculate how many of those subtasks check boxes have been completed. Is anyone able to help me with this formula?

After hours of looking how to do this I'm coming to a dead end!

Thanks so much!

2 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1260 replies
  • April 6, 2023

Hi,
Your goal is not clear. You mean this? (if not, please provide screenshot)


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • April 6, 2023

I think KBATA is using a single rich text field with checkboxes, not a series of checkbox fields. One complication is that each record could have a different number of checkboxes in the rich text field.

I think I created such a formula a while ago, but I am not on my computer and cannot look it up.