Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

Calculated columns

#Microsoft365 Day 243: Fix Text Case with Formulas in #SharePoint

One of my favorite formulas for data cleanup in Excel - and I didn't know I could use it in SharePoint. Winner winner chicken dinner if you ask me - this would fix a lot of that nasty Single line... Continue Reading →

#Microsoft365 Day 242: Calculate days between Dates with Calculated Columns in #SharePoint

Yup, still on those calculated columns in #SharePoint. So easy to use and they solve a lot o problems and save time. Today I'll show you how to calculate days between dates - the difficult and the easy way. https://youtu.be/d-J_RrZBqoo... Continue Reading →

#Microsoft365 Day 240: Percentage Profit with Calculated Columns in #SharePoint

Wanna do some cool calculations on your data (lists) in SharePoint. Here's a great example of using Calculated Columns to work out the profit and profit percentage for you. Of course you can then write filtered views that shows profit... Continue Reading →

#Microsoft365 Day 239: Add days to a date with calculated columns in #SharePoint

Here's a real nifty way to do your revision dates in controlled document libraries - automatically. Documents might have different revision cycles, so adding days as a cycle would then calculate the date it needs to be reviewed. Yup!! OTB... Continue Reading →

Day 282 – Data Cleanup Formulas for SharePoint

#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 →

Day 281 – ROUNDUP, ODD, or EVEN functions in SharePoint

#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 →

Day 280 – Calculate the Average of numbers SharePoint

#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 →

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 →

Powered by WordPress.com.

Up ↑