Sort checklist by unchecked and then checked?

[Gregg_Stebben]

Hi…
Checklists are wonderful, but it seems to me that would be even better if items went to the bottom of the list when you checked them so that all you saw at the top of the list was stuff that still needed to be done. Is there a way (formula maybe?) to do that?

Many thanks!
Gregg

[Nick_HE]

Yep! You can sort based on the checkbox column - use the dropdown when hovering on the column header. Does that work for you?

Edit: just to be clear, is you list in a table? It needs to be

[Gregg_Stebben]

Ahhh. So you can’t sort if the checklist is in a cell? That’s too bad, but ok. Thanks for helping!

[Paul_Danyliuk]

You can but you have to write some black magic code for it.

Here’s the thread (this and some further messages) that could give you some ideas how to detect each item’s status (checked/unchecked) by peeking into its state. You could make a button that would deconstruct and then reconstruct the checklist and insert it back into the cell.

Button to uncheck checklists

@Daniel_Stieber et al: A very good practice is to ask oneself: do I really need to do something, or is there an easier way. Or, “Do I need to resort to deep object modification” in this case If you need to uncheck all checklist items in a text field and every line in that text field is a checklist item the task can be rephrased as “Turn each line of text into an unchecked checklist item”. This can be solved much more easily by splitting the text down into lines and then con…

Caution: The ranges object is being deprecated, it seems. The new editor will introduce a new way of how rich text is stored in cells, the slate object. All previous hacks based on rich text will probably stop working.