SharePoint Events List – Group By Month

When showing a SharePoint Calendar control, the default view is the big “grid” of events.

image

But – there is another “view” that shows each item listed as with other SharePoint lists :

image

What would be nice is to have a group by “MONTH” so that you can have a text view, but easier to navigate.

Here’s what you need to do :

  • Click Settings > List Settings
  • Click Create Column
  • Enter a column name – eg. Month And Year
  • Change the Column Type to be “calculated”
  • Enter the formula as follows – basically formatting into YYYY-MMM format

=TEXT([Start Time],"MM-yyyy")

Now that the column is in place, it can be used in a “GROUP BY”.

  • Click on the View drop-down
  • Choose Create View

image

  • Click Standard View
  • Enter a name for the View  (eg. By Month)
  • Scroll down to the section for “Group By”
  • Expand, and choose the new column

image

  • Click OK to save the View details

The view should then display the list of events – grouped/sorted BY MONTH :

image

Nice, eh ?

🙂

Advertisements

One thought on “SharePoint Events List – Group By Month

  1. First of all I would like to say fantastic blog! I had a quick question in which I’d
    like to ask if you don’t mind. I was interested to find out how you center
    yourself and clear your thoughts prior to writing.
    I have had trouble clearing my mind in getting my ideas out there.

    I do take pleasure in writing however it just seems like the first 10
    to 15 minutes are generally lost simply just trying to figure out how to begin. Any ideas or hints?
    Kudos!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s