- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 08, 2023 04:23 AM
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 :
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 08, 2023 09:29 AM
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 ))