An ever-growing SharePoint list function reference
My way of explaining each function with as much detail as I can. You’ll find suggestions, best practices, things to avoid, and limitations.
Here are the sections where you can find articles. There are more in Microsoft’s reference, but I only include the ones I wrote about in the past.
- Aggregator
- Convert
- Data Conversion
- Data Selection
- Date
- Date Manipulation
- Date Operator
- Find
- Logical Operator
- Math
- String Manipulation
Aggregator
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 …Full Reference
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 …Full Reference
Convert
INT function
SharePoint int function in most programming languages is used to convert an “object” from one type to an integer. However, in the case of the …Full Reference
Data Conversion
Data Selection
IF function
“IF function” will return something if the first value is “true” and something else if the second is false. The “If function” is the most …Full Reference
Date
DAY function
“Day function” will return the day part of a date in a numeric format. For example, in the data 21st of January 2020, it will …Full Reference
HOUR function
The “hour function” is part of a suite of functions that deal with dates. It returns the part of the time; for example, 12:30 will …Full Reference
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 …Full Reference
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 …Full Reference
WEEKDAY function
Knowing the day of the week can be incredibly useful when it comes to formatting data. For example, you can have a column representing a …Full Reference
Date Manipulation
Date Operator
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 …Full Reference
Find
CHOOSE function
“Choose function” will return the value for a specific index. For example, if you have a set of values like “banana,” “orange,” and “apple,” the …Full Reference
Logical Operator
ISBLANK function
Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that no ugly #Value! are displayed on …Full Reference
ISERROR function
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 …Full Reference
ISLOGICAL function
The ISLOGICAL Function is not one of the most used functions, and it may not look as useful as others, but it has its useful …Full Reference
ISNA function
Following the “IS” functions theme, we have the ISNA function. This checks for the “#N/A,” an error that we know all too well in Excel. …Full Reference
ISNONTEXT function
Following the “IS” functions theme, we have the ISNONTEXT function. This function doesn’t check for errors, but if the value is of a specific type. …Full Reference
ISNUMBER function
The “ISNUMBER” function relates to a group of functions called the “IS” functions. These validate if the contents are of a specific type or returned …Full Reference
ISTEXT function
Following the “IS” functions theme, we have the ISTEXT function. This function doesn’t check for errors, but if the value is of a specific type. …Full Reference
Math
AVERAGE function
The average function draws a lot from Excel, where we can have one or more columns (or cells in Excel) and return the average of …Full Reference
ROUNDDOWN function
Rounding is a fundamental operation in math, but it can be tricky depending on what you’re rounding. That’s why having the SharePoint “RoundDown” function is …Full Reference
ROUNDUP function
Rounding number is sometimes necessary, and it’s an essential operation in math, but it can be tricky depending on how you do it. That’s why …Full Reference
String Manipulation
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 …Full Reference
LEFT function
The “Left function” is part of a group of functions that help us do text manipulation. The “left” gives us a hint into what it …Full Reference
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. …Full Reference
LOWER function
One of the trickiest things is to keep data consistent, especially if it’s inserted by the users. Each person has their way of providing data, …Full Reference
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 …Full Reference
RIGHT function
The “Right function” is part of a group of functions that help us do text manipulation. The “right” gives us a hint into what it …Full Reference
ROUND function
Rounding is a super valuable and essential math operation, but it can be tricky depending on what you want to do. Also, some rules rely …Full Reference
TRIM function
The trim function serves as an excellent helper tool to clean text. We all know that if we have five people inserting data into a …Full Reference