How to count number of checkboxes inside Notes/Canvas

Trying to count number of checkboxes inside the row’s Canvas/Notes cell in a table
So I can generate progress bar column based on the total number of checkboxes vs ticked in a specific cell

Is it possible?

Hi @Sergey_Govorunov !

That’s the topic of the moment !

Please have a look on the answer I gave to a fellow here : Progress bar column and formulas - #3 by Quentin_Morel

Please let me know if I misunderstood your point,

Quentin

3 Likes

Hi @Quentin_Morel !

Wow, that is exactly what I was looking for.

Total number

thisRow.[CANVAS COLUMN].Split(LineBreak()).Filter(
  ParseJson(
    CurrentValue._Merge() + "",
    "$..children[?(@.style == 'CheckboxList')]"
  ).IsNotBlank()
).ListCombine().Concatenate().Split(LineBreak()).Count()

Done number

thisRow.[CANVAS COLUMN].Split(LineBreak()).Filter(
  ParseJson(
    CurrentValue._Merge() + "",
    "$..children[?(@.style == 'CheckboxList' && @.isChecked)]"
  ).IsNotBlank()
).ListCombine().Concatenate().Split(LineBreak()).Count()
2 Likes

All the mastering goes to @Paul_Danyliuk , I just asked this question again last week :wink:

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.