November 6, 2024

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.
Experience
I’ll include all my experiences (good and bad) working with the functions.
For everyone
I want people to use it and share it. So I won’t put any restriction on it on this reference.
By everyone
Please contribute! The better I can make it, the better it will be for everyone.
Lots of places
I learn from lots of places, so some things may be found elsewhere.

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

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
Mastodon