Grouping a List View by a Calculated Date Field

If you’ve been ultra efficient and create a calculated Date Field that will display the month and year (e.g. Aug 2015) of a date column so that you can group something like News Articles in this way, you may have already discovered that grouping your list view using this new column displays the group header as blank. When you include the calculated field in your view, you see it has value BUT the won’t display in the group header.

I found a work around for this – simply edit your view and change the style to Basic Table. I also played around with default expansion of the groupings. This should now display your calc field group headings and display any items underneath.

Advertisements

One thought on “Grouping a List View by a Calculated Date Field

  1. You could also create a new column on the list. The new column on the list is also a calculated value, but in the formula you would do something like this: =TEXT([Onsite Date], “mm/dd/yyyy”). Make sure the calculated value is a single line of text. If you use the date and time type, it still will not work.

    This is a pain since you have to add a new column, but works nontheless since you don’t have to show the column in the view (doesn’t add clutter).

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