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