Is there is a way to change the export to excel function on the hierarchy tab to export in the order that is displayed on Clarity screen rather than alphabetically?
There is manual effort to reorder the projects as they appear in Clarity.
The Hierarchy tab will sort only in ascending or descending order as the sorting is configured by what is dislayed in the Configure > Multisort page.
This is working by design as what already appears in the Hierarchy tab is what is exported.
If this area needs to be enhanced, this will need to be an enhancement request.