Solved

How to Sort a  Sharepoint Column type

Posted on 2011-02-16
4
439 Views
Last Modified: 2012-05-11
I am looking for the functionality where I have a title and clicking on the title, I would be redirected to a link. So my link s are not visible on the list view. I have done this using "hyperlink with formatting and constraints for publishing" column type. But now I see that the column does not sopport sorting alphabetically like other column types. Can this be achieved using calculated column, if so what should be given as the formula?
0
Comment
Question by:sumachandu
  • 2
4 Comments
 
LVL 3

Expert Comment

by:matsonpp
ID: 35070229
Unfortunately calculated fields cannot use special fields like: Lookup, Hyperlink, Multiple lines of text. You might want to consider creating a SharePoint Designer dataview to be able to sort.
0
 
LVL 3

Accepted Solution

by:
matsonpp earned 500 total points
ID: 35072843
Check this out. This is how to get a calculated field to use a rich text field and as the result is text, it looks to me like it's sortable:

http://www.endusersharepoint.com/2009/10/21/taming-the-elusive-calculated-column-referencing-a-multiple-lines-of-text-column-with-append-text-part-1/

Regards,
m
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 37412109
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

746 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

12 Experts available now in Live!

Get 1:1 Help Now