SharePoint: ISLOGICAL Function
by 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 …
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: 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 …
SharePoint: 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 …
SharePoint: 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. …
SharePoint: 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. …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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 …