Change the order of Summary report Columns
I have created a summary report with work status as the column heading and the report works fine but the headings are in alpha order by default. I would like to change the order so that the columns ...
Forum Discussion
I'm not certain there is a way to force the order of [Status] values to be alphabetical. Can you make a formula text field that reads the [Status] field and places a number in front of the value?
[Status_]
if(
[Status]="Initiated","1-Initiated",
[Status]="Scheduled","2-Scheduled",
[Status]="In Process","3-In Process",
[Status]="Completed","4-Completed",""
)
Make a duplicate summary report and try this to see if the aesthetics of the leading number is appealing. Change the summary column to this formula [Status_] field.