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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cool tip HappyFunBall !
Partha
Partha
@Replace(Priority; "Urgent":"High":"Medium":"
You can unsort your column then.