Order of checkbox elections in reporting

[ThomasNe2]

I am pulling reports for some teams who need view of a custom field in a report. 

This custom field shows the names of teams but when pulled into a report they appear in a different order each time. 

Is there a reason for this and is there a way to change it? 

[Kurt_Jones]

Thomas, this looks like a calculated field.  There are some expressions in the calculated editor you can use such as SORTASCSTRING or SORTDESCSTRING to help this list be in a sorted order.

[ThomasNe2]

Hi Kurt - not calculated - just a checkbox custom field. 

[MoniqueEvans]

Unfortunately, I haven't found a way in the system to sort these and often have to export the results to Excel. @Doug_Den_Hoed__AtAppStore do you have any clever tricks up your magical sleeves?

[Daniel_Clarke · Accepted solution]

Hey @ThomasNe2 - 
Kurt's solution can still work for you, you can add a calc field that sources the checkbox and then do the sort against that field and point your reporting to that new calc field. This will also allow you to group by the field - something you cannot do against a checkbox field!

You can place this calc field down in an admin only section as well so it is not interfering with the UI of the form.

New text based calculated field:

REPLACE(REPLACE(SORTASCARRAY(ARRAY({DE:FIELDNAMEHERE},' , ')),'["',""),'"]',"")

[Doug_Den_Hoed__AtAppStore]

Very nice @Daniel_Clarke,

That's a new one for me, but I like it! Thanks for sharing!

Regards,

Doug