Applying Sorting to a Column by Another Object


You wish to apply sorting to a column by an object but not actually add the column with that object. For example, you wish to sort the Project Name column by its reference number but not include the column with the Reference Number.



To do that you will need to:

  • Open a new or the existing Project Report
  • Add the Project Reference Number column
  • Click to sort by that column
  • Switch to Text Mode
  • Copy the three lines from there:


  • Remove the Reference Number column
  • Click on the Project Name column
  • Switch to Text Mode
  • Paste the code 
  • Save And Close

Now your Project Name column will be sorted by the Project reference number but the Reference Number column will not be visible in the Report.  


This article last updated on 2018-04-04 14:04:56 UTC