SharePoint Calculated Column – how to work around


Q: I work in Communications and we collect the news related to our department and send it out by email twice daily, once in the morning and once in the afternoon. I have set up a SharePoint library to group by Date, so it groups uploaded files by the date they were added, which is great. I was wondering if I could group the files under these dates by morning and afternoon (ie. before 12:00 and after 12:00) so by the time that they were added, so that they correspond with our morning and afternoon news alerts?

calculated fieldThats possible:
create a new SharePoint calculated column in the list/library. In the calculated field copy and paste between the quotes “=IF(HOUR(Modified)>12,”PM”,”AM”)”
Save.

Go to view and and group by date and second by this calculated field. This solutions is posted on the below forum by me and wanted to add it to by blog for further reference:
http://sharepoint.stackexchange.com/questions/141988/grouping-columns-by-date-and-time/141997#141997

Detailed help in these links: https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

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 )

Connecting to %s