Use checkbox progress from Long Text field in a formula?

[Damien]

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).

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!

[rdb]

Unfortunately, this is currently not supported.

[bha]

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

[Damien]

Thanks for your feedback

[Damien]

Nice thank you for the tips