I am trying to create a few spreadsheets to track progress in mapping efforts and have a situation where I want to sort rows in the spreadsheet based on the numerical value of an attribute rather than the name of the listed object. This needed in order to produce a list of functions in order of appearance rather than the alphabetical order. Content is found in a query and saved for further work in a project based spreadsheet. No matter how I try I end up with a lot of cells with missing references. If I try to sort with only plain text entries everything is ok.
1. Is it possible to do any kind of sorting already in the query results?
2. Is it possibly to sort rows with formulas containing references to the ARIS db?
Edit: I'm on 9.6