Merry Christmas to all who celebrate!
Has anyone figured out a way to sort a checklist that’s inside a cell by checked and unchecked?
I wonder if some kind of “If” formula could do this and I am going to give it a try…but I thought maybe someone already figured it out, so asking.
Hey Gregg!
Merry christmas to you too 
I got a working example for you, using _Merge().ToText() on the checklists we expose some json attributes we can search for using this formula
Thank you so much!!!
What a nice holiday gift!!
I can’t wait to try it!!
I definitely never would have figured this out on my own…thank you, thank you, thank you!
Just got a chance to apply this, it works great! Thank you @Rickard_Abraham!!
Follow up question:
Since some cells in a column contain a checklist or other cells do not, is there a way to display the sorted checklist when a checklist is present and a blank cell if no checklist is present?
Many thanks!
Gregg
Sure, we can just search for a presumable always present json attribute for a checklist, updated the formulas
Fantastic! Thank you so much!! Looking forward to buying you a coffee!!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.