Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

Office 365

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

#Microsoft365 Day 238: Validate length and number only with Column Validations in #SharePoint

In this example, I would like to validate the length of the ID number as well as that it only contains numbers. Of course if it must be numbers, just use a number column, but if it's meant for ID,... Continue Reading →

#Microsoft365 Day 237: Validate Email Addresses in #SharePoint with Column Validations

Using a single line of text for email addresses are tricky, as there's no checks. If you use column validation it can at least do a couple of checks for you. See how we can validate whether an address includes... Continue Reading →

#Microsoft365 Day 236: Validate dates in #SharePoint with List Validations

Here's another great OTB function in SharePoint, that allows you to validate the data in your list, which gives the user an error on the form. In this example I'll show you how to validate that a delivery date must... Continue Reading →

#Microsoft365 Day 235: Exclude Apps from Search results in #SharePoint

Another great OTB function in SharePoint is to exclude libraries and lists from Search results. You might be wondering why on earth you'd do that - but in the example I've excluded a Document Types Lookup list. Even though everyone... Continue Reading →

#Microsoft365 Day 234: Enforce Unique Values for Metadata in #SharePoint

The Enforce Unique Values is a great OTB SharePoint functionality which allows you to set a list or library, to not allow items with the same value. This of course can cause a lot of trouble if that was not... Continue Reading →

Up ↑