SharePoint Lists: Grouping/Paging by first letter
A very interesting blog entry, Alphabetical Paging on a SharePoint List View, by Tom Clarkson, talks about grouping/paging items in a SharePoint list based on their first letter.
If you are just looking for the formula needed to create a calculated column that contains the first letter of the item's Title, here it is:
=IF(ISNUMBER(VALUE(LEFT(Title,1))), "0", LEFT(Title,1))
Labels: Microsoft, MOSS, SharePoint
posted by Unknown at
12:08 AM
1 Comments:
I've never posted a comment before, but this hint was so valuable! Of course it's the solution I was looking for, but it never occurred to me to use a calculated column - thanks!
By
Anonymous, At
July 27, 2011 at 7:11 AM
Post a Comment
Subscribe to Post Comments [Atom]
<< Home