I have recently upgraded our 2007 envrioment to 2013 and afterwards a few of our libraries are having trouble grouping on a calculated column. The year column is calculated using the following formula ( =TEXT([As of Date],"yyyy") ). When a document is added or edited in the library the year group it was in gets duplicated as in the screen shot below. I can fix the issue be re creating the calculated field and fixing the view, however as soon as a document is edited or added it starts all happening again.

Any Ideas?

Grouping Issue

  • i'm having trouble getting the screen shot to show. But basically there are 2 2013 groups and 2 2012 groups in the view.
    – kds6253
    Aug 16, 2013 at 18:54

4 Answers 4


I am seeing the same issue after we just upgraded a customer to 2013. Pretty much the same issue. We have a calculation using the LEFT function to get the first letter of a title so that we can group from A-Z. By opening the calculated column settings and just clicking OK it fixes it. But the problem keeps coming back after anything is edited. Would love to know if you find a solution.

  • glad to see i'm not the only one. It looks like it is happening in all of our site collections where we group on a calculated field.
    – kds6253
    Aug 20, 2013 at 20:35
  • which version of sharepoint are your running currently?
    – kds6253
    Aug 20, 2013 at 21:05
  • Our customer is on the March CU. I hesitate to apply a later unless I know it specifically will address this issue.
    – user19039
    Aug 22, 2013 at 16:29

After speaking with microsoft the June CU fixes this issue. We have tested on both our dev and QA enviroment and we are rolling it out to PROD this week.


Same issue. Workaround that worked with me: update all items (or files) of the library. I have done a bulk update easily copying pasting one column to the same column. Now there are no more repeating groups in the list.


Are you on the latest CU? I have heard a few reports of XSLT not playing nicely in 2013 so this could be another example of that as opposed to an issue with the calculated column.

  • We are not, I will look into updating. But Would still like to see if anyone else has had a similar issue and what their resolution was?
    – kds6253
    Aug 19, 2013 at 14:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.