Help

Create a progress bar that is link to a subtask field who use checkbox

Topic Labels: Formulas
579 1
cancel
Showing results for 
Search instead for 
Did you mean: 
romain_portlabs
4 - Data Explorer
4 - Data Explorer

I hope you're all well. I have a question to ask you, I would like to create a progress bar that summarises all my subtask using checkboxes. Basically, each time I check all the checkboxes in my subtask, the progress bar shows me 100%.

Is this possible? Can anyone help me?

 

I'm looking for something like this : 

1 Reply 1

Hi,
I think, something like 

LEN({Field})-LEN(SUBSTITUTE({Field},'[X]','[]')

 is checked  and the same with a space instead of is unchecked
and then checked / (checked+unchecked)
be careful with brackets, enclose numerator as well, otherwise A+B / (C+D) might surprise you with a result.


Possibly, regex might significally shorten the formula, but when I thought about square brackets, I've lost my inspiration to create it, so better ask chatbot ))