SharePoint: REPT Function
by “REPT function” will return a text value that has a specific string repeated X number of times. Usage It follows a simple pattern. String to …
Category: Microsoft 365 Copilot
In my opinion, Microsoft has with Microsoft 365 Copilot the complete set of tools in the market. It was known previously as Office 365 (and Microsoft 365), and it contains a lot of cool stuff for us to use. I’ll focus on a few of them here for now.
I write articles periodically for SharePoint, Microsoft Planner, Microsoft Teams. But I also publish stuff about Microsoft OneDrive, Microsoft Lists, and Microsoft Graph.
One thing I won’t talk about is licensing. Although Microsoft is doing a great job simplifying the pricing and tools that you have or do not have access to on Microsoft 365 Copilot, it’s still quite complex and changes. So instead, I’ll focus on the best of the platform. You’ll make the best decisions about what makes sense to you.
SharePoint: Now Function
The SharePoint Now function will return the token serial number of the current date and time. Dates are stored internally as sequential serial numbers to enable …
SharePoint: Today Function
The SharePoint Today function will return the number of elapsed days since a reference date, in this case, December 31, 1899 (serial number 1). These are …
SharePoint: Easily create items with Quick Edit
Inserting data in SharePoint is quite easy. SharePoint’s customizes its forms to your data types, like displaying dropdowns for “Choice” columns, for example, so that you can insert …
SharePoint: DateDif Function
“DateDif function” will return the difference between two dates based on the unit supplied. The units can be: Y(ear) M(onth) D(day) M(onth)D(day) Y(ear)M(onth) Y(ear)D(ay) Please note …
SharePoint: How to show additional columns in Views & Lists
SharePoint Lists provide you with loads of extensibility with, not a lot of code or expertise. You can create the data and, with low effort, …
SharePoint: OR Function
Welcome to Function Friday. This week we’ll explore Microsoft’s SharePoint List Function “OR” function. This function will return Yes if any of the arguments are True. If any of …
SharePoint: Len Function
“Len function” will count the number of provided characters in the parameter. It will count them all, including spaces. Usage To use it, it’s quite simple. …
SharePoint: Calculated fields Goodness
SharePoint has a lot of excellent features, being one of my favorites, having the possibility to have calculated fields in lists. Calculated fields are what …
SharePoint: AND Function
Welcome to Function Friday. This week we’ll explore Microsoft’s SharePoint List Function “AND” function. This function will return “Yes” if all arguments are “true”. If any of them are …