Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

What determines the display order of values from a multi select field in Reporting?

Avatar

Level 2

We have a custom field related to which fiscal year(s) a project will impact. The field is a multi select, checkbox and the choices are in order by year, e.g. FY20, FY21, FY22, etc. When I pull this field into reports the values populate in random orders, I would like them to display in order according to the choice number on the custom form. Is this a setting/preference I need to update?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

Hi Joanna,

Although there might be some unseen sorting behind the scenes, I suspect otherwise, and I am not aware of any such setting.

In theory, it might be possible to create a second calculated parameter that inspects the multi-select using CONTAINS (for example) in The Right Order and thereby returns the selected values in the order you require.

Another approach would be to separate each into its own "single" check box, which (although it takes up a bit more real estate) also has some advantages in that they can be used to easily drive groupings and charts...and for that matter (same coin, flip side) could be recombined (in The Right Order) with a CONCAT formula in a calculated parameter.

Regards,

Doug