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?

Kind regards

/ Erik

Edit: I'm on 9.6

Featured achievement

You blog more than you breathe, and your articles stand out: Create 20 more articles, receive very good feedback and stimulate conversations
Recent Unlocks


Weekly | All-time
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon