Order of checkbox elections in reporting

Forum|Forum|11 months ago
March 14, 2025
3 replies
583 views

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?

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Daniel_Clarke

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},' , ')),'["',""),'"]',"")

Kurt_Jones

Community Advisor

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.

T

ThomasNe2Author

Level 4

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

MoniqueEvans

Community Advisor

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

Community Advisor

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: