Help

Formula HELP: Percentage of checked boxes in cell

Topic Labels: Formulas
551 2
cancel
Showing results for 
Search instead for 
Did you mean: 
KBATA
4 - Data Explorer
4 - Data Explorer

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 2

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

Alexey_Gusev_0-1680786430318.png

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.