Progress bar column and formulas

3

Hi @d_y

I asked the same question last week. If I assume that your Future Steps column is a canvas with only checklists, here is the solution, thanks to @Paul_Danyliuk > Access Checklist info inside a canvas

  • You must split your canvas column with Split(Linebreak)
  • Then use Paul’s Code for both checked and unchecked tasks
  • Create columns with .Count() to count the both columns mentionned before
  • Create the total
  • And finally in your progress bar, you can for example set max to 1, and make a formula with CheckTasksCount/TotalTasksCount to have the %, like in my own document

image

Hope this is OK ?

Quentin

3 Likes