Get year of created date in a calculated column

If you need to extract year from created value, just create new column  and use the following formula:




New column should be single text in order to use its value in views and filters, because date format is not supported.

Messages sent from a shared mailbox aren’t saved to the Sent Items folder of the shared mailbox in Outlook 2013


  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate and then click the following registry subkey:
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type DelegateSentItemsStyle, and then press Enter.
  5. Right-click DelegateSentItemsStyle, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.

How to change Sharepoint 2013 theme on MySite?

If your “Change the look” link is missing in Site settings, you cannot change theme easily. However, all SP sites have the same URL paths for many options, and you can simply type direct URL for themes.

All you have to do is to simply add “/_layouts/15/designgallery.aspx” to the URL address. Example: http://mysite/_layouts/15/designgallery.aspx. Now you can apply custom theme to MySite

Keep in mind that MySite uses special master page (mysite15.master). It is important to update new composed look with this master page URL.

Enjoy Sharepointing! IMAP Mail Server Settings

Account type: IMAP
Incoming mail server:
Outgoing mail server (SMTP):


Logon Information:
User Name: your email address
Password: your password


Then click on the “More Settings” button:
Outgoing Server tab: mark the box “My outgoing server (SMTP) requires authentication” and select “use same settings as my incoming mail server”.


Advanced tab – Server Port Numbers:
Incoming server (POP3): port 993
– you must also mark the box “this server requires an encrypted connection (SSL)”
Outgoing server (SMTP): port 587
– you must also choose “TLS” for the option “Use the following types of encrypted connection”.