Making your life easier!
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.
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 …
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 …
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 …
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. …
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. …
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 …
“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 …
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 …
“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 …
“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 …
by 
