SharePoint: ISNONTEXT function
by 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. …
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: 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 …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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, …
SharePoint: 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 …
SharePoint: 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 …
SharePoint: 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 …