#Office365Challenge So lookups are pretty cool, and yes, it saddens me to have "limitations" in the title, but it's true. However, read on and I'll show you some cool tips to get around that! Day: 283 of 365, 82 left Tools:... Continue Reading →
#Office365Challenge To conclude my posts around calculated column formulas in SharePoint, I'd like to share my favourites for data cleanup. Day: 282 of 365, 83 left Tools: Office 365, SharePoint Description: Data Cleanup Formulas for SharePoint Audience: All Related Posts: Day 275 –... Continue Reading →
#Office365Challenge Nope, didn't know I could do that in SharePoint. Of course being able to calculate ROUNDUP, ODD, or EVEN values in SharePoint is a great way to save time on reworking data. Day: 281 of 365, 84 left Tools: Office... Continue Reading →
#Office365Challenge Of course working out averages across columns adds value - why export it to Excel to analyse data when you can do it in SharePoint? Day: 280 of 365, 85 left Tools: Office 365, SharePoint Description: Calculate the Average of numbers SharePoint Audience:... Continue Reading →
#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 →
#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 →
Tracy van der Schyff 