Use checkbox progress from Long Text field in a formula?

User Talk Columns
1

Hi,

I am using a Long Text field where I create a task list with checkboxes.

In the record view, I can see the progress indicator showing the number of checked items (e.g. 1/3, 2/3, 0/3).

image
image216×150 1.56 KB

My question is:

Is it possible to use this checkbox progress value inside a formula field ?

For example, I would like to automatically determine if all tasks are completed (when all checkboxes are checked) and return something like:

  • “Completed” if everything is checked

  • “In progress” otherwise

Is this progress data accessible in formulas or script, or is there another recommended way to achieve this ?

Thanks in advance for your help!

2

Unfortunately, this is currently not supported.

3

Hi @Damien,
You could actually use the formula if(iserror(search("[ ]",{Checklist},1)),"Completed","In progress") which might do the job… To explain how it works, it actually looks for the [ ] characters (unchecked checkbox) in the content of your Checklist column.

  • If found, it return false (the search function actually returns the position of the first found item in the string, which is not an error > the iserror function returns false)
  • If not found (every checkboxes are checked), the search function return an error (because no valid position were found) > the iserror function returns true).

Please note that as the formula is based on the search of the [ ] characters which is the markdown representation of an unchecked checkbox, it won’t work anymore if you use this pattern elsewhere in your Checklist row content!

Bests,
Benjamin

4

Thanks for your feedback

5

Nice thank you for the tips :grin: