Tag Archives: formula

Create Unique Keys Using Calculated Fields

This little trick is something that should have struck me long ago, but I just recently hit upon it. I had a situation where I needed to create a column in a list that looked up data from another list. Normally, lookup columns use the Title field as the text displayed in the [...]

Posted in Lists and Libraries, Tips and Tricks | Also tagged , | 1 Comment

Week Ending Column in SharePoint List

I was recently working on an excel pivot table report that pulls its data from a SharePoint list. One of the business requirements was to be able to sort, filter, and/or group by a “Week Ending” date. The list has a column called Action Date which could be any day/date. The solution [...]

Posted in Tips and Tricks | Also tagged | 3 Comments