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 :
Hi,
I think, something like
LEN({Field})-LEN(SUBSTITUTE({Field},'[x]','[]') is checked and the same with a space instead of x 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 ))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.