Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

2016Week48

Day 279 – SharePoint Show dates as days of the week

#Office365Challenge This formula allows you to calculate the day of the week for the date and returns the full name of the day. Day: 279 of 365, 86 left Tools: Office 365, SharePoint Description: SharePoint Show dates as days of the... Continue Reading →

Day 278 – SharePoint Using ABS Function

#Office365Challenge Here's an easy formula to calculate the difference between two columns and display the result as a percentage. Day: 278 of 365, 87 left Tools: Office 365, SharePoint Description: SharePoint Using ABS Function Audience: All I'll admit - I used to... Continue Reading →

Day 277 – SharePoint Calculate difference between two dates

#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... Continue Reading →

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

#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... Continue Reading →

Day 275 – SharePoint: Hide error values in calculated columns

#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... Continue Reading →

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

#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:... Continue Reading →

Day 273 – Change the Theme in Microsoft Office

#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... Continue Reading →

Powered by WordPress.com.

Up ↑