SharePoint: ISERROR Function
by Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that you don’t display to the user …
Category: SharePoint List Function Reference
This SharePoint List Function Reference has two main objectives. The first is to explore the fundamental concepts and understand them better. The second is to provide some feedback on how to use them efficiently.
I don’t want for this SharePoint List Function Reference to replace the excellent Microsoft reference, but I want to augment it with some information that you only find once you use the tools.
SharePoint: CONCATENATE Function
“CONCATENATE function” will group a series of values into a unique string. I like the concatenate function since you can use more than strings. Usage …
SharePoint: REPT Function
“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 …
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: 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: 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: 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 …