View Hierarchy - Non-alphabetical sort

Hi all-
I would like to create a view that allows me to control how I want a field value sorted.  
The specific example is that I have a field that indicates the importance of a form.

The available values are:
Urgent
High
Medium
Low

I would like to sort it this way, but every time I create a view, it defaults to sorting it alphabetical, like this:

High
Low
Medium
Urgent

I would like to be able to reverse the sort too.

Thanks for your help!
Aquilon7Asked:
Who is Participating?
 
HappyFunBallConnect With a Mentor Commented:
In a column to the left of the category, put in this formula:

@Member(CATEGORYFIELDNAME; "Urgent":"High":"Medium":"Low");

Enter your category field in place of CATEGORYFIELDNAME

Also set the column to sort ascending.  The function will return 1 for Urgent, 2 for High, etc...
0
 
Sjef BosmanGroupware ConsultantCommented:
Insert a hidden column, sorted ascending, just to the left of your column, with a translation formula, like
    @Replace(Priority; "Urgent":"High":"Medium":"Low"; "A":"B":"C":"D")

You can unsort your column then.
0
 
p_parthaCommented:
Cool tip HappyFunBall !

Partha
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.