Can you use formulas to pull out checklist items from pages/tables/canvas elements?

[Xing_Su2]

We use the simple checkboxes very often in the various parts of our internal document, and some times it’s difficult to track what all of the open items in one places.

I know that if you can use particular text cues/prefixes such as "AI: ", you can then use split(character(10)) and startsWith() to filter out items, but does anybody know how to actually reference /checkboxes in pages/tables/canvas elements?

[Daniel_Stieber]

Hey @Xing_Su2
the master of Coda Hacks @Paul_Danyliuk found a way to extract checkboxes from Columns and even check/uncheck them.

Check this thread

Extract checked checkboxes from a column

P.S. Here you go. Note that I’m not doing anything cool with indenting. E.g. if you have nested checklist items, it will not smartly resolve incomplete parent items or such. It will simply filter for lines that are checked/unchecked and combine those together:

Best
Daniel