Day 277 – SharePoint Calculate difference between two dates

Standard

ATOI365D#Office365Challenge If you need to calculate the difference between dates (on SharePoint), it’s a lot easier than you think.

Day: 277 of 365, 88 left
Tools: Office 365, SharePoint
Description: SharePoint Calculate difference between two dates
Audience: All

You require two date columns in your library/list (I’ve just used the Created and Modified columns).

Create a calculated column, select the columns and add a minus “-” between the columns:

021216001

Here you’ll see the value automatically populated:

021216002

You can also calculate the difference in months and even ignore the years:

021216003

 

Yay for formulas!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 276 – SharePoint Calculated Field Formulas – add days to dates

Standard

ATOI365D#Office365Challenge Adding days to dates is something I use often to calculate review dates in SharePoint. Let me show you how.

Day: 276 of 365, 89 left
Tools: Office 365, SharePoint
Description: SharePoint Calculated Field Formulas – add days to dates
Audience: All

To add a certain number of days to a column can be done in different ways. If the review date on all the documents in your library is 1 year for example, the calculated column formula could simply read “Modified Date + 365”.

However, if you want to be selective on the number of days till review (per document), you would need to add an extra column for number of days (number column), and then the calculated column which adds these.

In my example, my calculated column adds the Modified (date) and Days to Review (number) columns together. The important thing would be to display the result as a date:

011216001

As mentioned, you can now enter different time periods for different documents and it will calculate the review date:
0112160012

You can also add Months and Years in a similar way:

0112160013

Read more…. from Microsoft.

A reminder about the use of Commas or Semicolons in formulas, read Day 44 – Excel / SharePoint Formulas using Commas or Semicolons for more information.

Yay for formulas!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 275 – SharePoint: Hide error values in calculated columns

Standard

ATOI365D#Office365Challenge Sometimes columns give errors due to no data completed or invalid data. This post will show you how to change your formula in your Calculated Column, to not show errors.

Day: 275 of 365, 90 left
Tools: Office 365, SharePoint
Description: SharePoint:  Hide error values in calculated columns
Audience: All

Nothing as annoying as the #DIV/0! error, right?!?!
301116001

On the left you’ll see my original column, on the right, the modified column which will hide the error (or exchange with NA):

  1. =[Income]\[Months]
  2. =IF(ISERROR([Income]/[Months]),”NA”,[Income]/[Months])

301116002

End Result:
301116003

Keep in mind that formulas might differ based on the version you’re working on. Read my post Day 44 – Excel / SharePoint Formulas using Commas or Semicolons for more detail.

Told you, Microsoft’s amazing.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 274 – Share a document by sending or posting an anonymous guest link

Standard

ATOI365D#Office365Challenge Did you know you could share a document outside of your organisation, for people to collaborate on?

Day: 274 of 365, 91 left
Tools: Office 365, SharePoint
Description: Share a document by sending or posting an anonymous guest link
Audience: All

Oh yes you can!!

And it’s rather easy if YOU have the right permissions to do so.

  1. Select the document
  2. Click on Get a link
  3. Copy the link
  4. Set the expiration
  5. Voila! !!

291116001

You can now share this link via whichever platform you prefer. Blog, Twitter, Facebook, Email etc.

291116003

It will open the document for the person in the Web to edit and add their bit. 

291116002

Told you, Microsoft’s amazing.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 273 – Change the Theme in Microsoft Office

Standard

ATOI365D#Office365Challenge Bored with the white & blue Office. Well never fear, when Microsoft is near. Here’s a reminder that you can change the themes for your Office.

Day: 273 of 365, 92 left
Tools: Office 365, SharePoint
Description: Change the Theme in Microsoft Office
Audience: All

I’ve changed my theme in Outlook.

  1. Click on File
  2. General
  3. Office Theme

281116005

 

I’ve chosen the Black theme and this is what it looks like:
281116006

 

Keep in mind that the theme affects all Office programs, this is my Excel now:

281116007

Have fun. Don’t be boring!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 272 – Download multiple documents in SharePoint as zip

Standard

ATOI365D #Office365Challenge And yes, it’s possible to select multiple files in SharePoint Online and download as a zip file.

Day: 272 of 365, 93 left
Tools: Office 365, SharePoint
Description: Download multiple documents in SharePoint as zip
Audience: All

Here’s another time saver which will cut out a lot of frustration.

In SharePoint online, you can now select multiple documents and then download them. It will download the doucments in a zip folder in your downloads directory.

  1. Select documents
  2. Click on Download
  3. Choose to Open or Save

271116001

Downloaded Zip Folder:

271116002

Expanded Documents:

271116003

Thanks Microsoft!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 271 – Outlook: Forgotten Attachment Reminder

Standard

ATOI365D#Office365Challenge Ever sent an email and forgot to attach the document? Yup, we all have.

Day: 271 of 365, 94 left
Tools: Office 365, Outlook
Description: Outlook:  Forgotten Attachment Reminder
Audience: All

Here’s a goody!  We’ve all done it, sent an email without the attachment only to realise it afterwards. Painful.

Sooooooo….. When using the word “attach” or “attachment” Outlook will check whether you have an attachment on the mail, and if not – remind you to attach it:

261116001

Thanks to Taylor Gibb for the post How to Enable or Disable The Forgotten Attachment Reminder in Outlook 2013 should you wish not to use it.

Microsoft – making me a better person – every single day🙂

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 270 – Outlook on my Android phone

Standard

ATOI365D#Office365Challenge Might seem like something everyone know, but there is still lots of people out there with ‘normal’ mail clients on their phones.

Day: 270 of 365, 95 left
Tools: Office 365, Outlook
Description: Outlook on my Android phone
Audience: All

So as mentioned, Outlook is available on our phones. Go to the Play Store and search for Outlook. Install the Microsoft Outlook App. Once installed (and you’ve entered your credentials to load your account), you’ll have the Outlook Icon. In Outlook you have access to your mails (I have two mailboxes installed and it displays my mails combined under focused and other):

 

251116001

At the bottom of the screen you’ll see 4 icons. Mail, Calendar, Files and Contacts. These will of course display your Mail, Calendar, Files on mails and Contacts.

251116002

Much better app to use than other mail apps out there, and allows you to be in touch wherever you are.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 269 – SharePoint: Dragging files into libraries and folders

Standard

ATOI365D #Office365Challenge Apart from being able to drag documents into the library via web browser, the new modern libraries also allows dragging into folders.

Day: 269 of 365, 96 left
Tools: SharePoint Online
Description: Dragging files into libraries and folders
Audience: End User / Power User

In SharePoint 2013 / SharePoint Online, you can drag documents straight from your File Explorer into the library (web browser). Simply split your windows or overlap and drag from your File Explorer into the library (be cognizant of compulsory metadata / checked out files that needs to be completed afterwards):

241116001

But wait, there’s more…..

In the new Modern look libraries (without the ribbon), you are able to select and drag files to a pinned folder at the top of the library:

241116002

You can also select and drag files into a folder (not pinned). And yes, you can actually drag a folder into another folder as well:

241116003

Stop dragging your feet, drag those files rather🙂

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Day 268 – Pin folders or documents in SharePoint

Standard

ATOI365D #Office365Challenge In a library with 1000’s of documents, the ability to pin important documents or folders to the top is invaluable.

Day: 268 of 365, 97 left
Tools: SharePoint Online
Description: Pin folders or documents in SharePoint
Audience: End User / Power User

In the new modern libraries in Office 365, we have the ability to pin folders and documents to the top of the library.

Why would you use this? If you want to put focus on a specific folder / document.

How would you do this?

Click on the ellipses next to the document of folder, click on Pin to top.

231116001

The files or folders will now appear at the top. You can only pin 3 items at a time:

231116002

Just another small thing that makes a big difference!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.