Sorting column by personal order

Posted on 2004-10-21
Last Modified: 2013-12-18
Hi, I would like to sort a column of text values based on my own personal order (i.e. not alphabetical).  How can I do that?  Thanks.
Question by:pw05
    1 Comment
    LVL 9

    Accepted Solution

    Do you have access to edit the view?

    If so, you can create a hidden column and place it as the first column in the view.  Set the column to sort Ascending.  For the formula of the column, you can use the following:

    @Member(<your field name goes here>; "<value1>":"<value2>":"<value3>":"<value4>":"<etc>");

    That formula basically uses the value in a field you choose and tries to find it in the list you provide.  The formula returns the position in that list, which will become the sort order for that row of the view.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    934 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now