Duplicates in SharePoint Datasheet view / Export to Spreadsheet (Excel)

Recently I encountered a bug in SharePoint where sometimes duplicate items appear when viewing items in Datasheet view in SharePoint.  This also happens when using the Export to Spreadsheet (Excel).  If duplicates appear in Datasheet view, they will also appear during Export to Spreadsheet and vice...

Group by month, year, or anything else using a calculated column in SharePoint

I found an excellent example of how to group by month in a blog recently. It does require using SharePoint Designer, however. An alternative to grouping this way is to create a calculated column and group on that. The end result looks something like this: : Basically, you just create a new calculated column...