Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Sorting column by personal order

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.
0
pw05
Asked:
pw05
1 Solution
 
HappyFunBallCommented:
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now