An ever-growing SharePoint List Functions
My way of explaining each function with as much detail as I can. You'll find suggestions, best practices, things to avoid, and limitations.
Last updated
I'll include all my experiences (good and bad) working with the functions.
I want people to use it and share it. So I won't put any restriction on it on this reference.
Please contribute! The better I can make it, the better it will be for everyone.
I learn from lots of places, so some things may be found elsewhere.
Aggregator (2)
Go to topConvert (1)
Go to topData Selection (1)
Go to topDate (5)
Day
Returns the day-of-month number from a date.
ViewHour
Returns the hour component (0-23) of a date or time value.
ViewNow
Returns the current date and time as a serial number.
ViewToday
Returns today's date as a serial number.
ViewWEEKDAY
Returns the day-of-week number from a date. Three return-type options.
ViewDate Operator (1)
Go to topFind (1)
Go to topLogical Operator (7)
ISBLANK
Returns true when a column is empty.
ViewISERROR
Returns true when a formula evaluates to an error.
ViewISLOGICAL
Returns true when a value is a boolean.
ViewISNA
Returns true when a value is the #N/A error.
ViewISNONTEXT
Returns true when a value is anything other than text.
ViewISNUMBER
Returns true when a value is a number type.
ViewISTEXT
Returns true when a value is text.
ViewMath (3)
Go to topString Manipulation (8)
CONCATENATE
Joins strings, numbers, and formulas into a single value. Up to 30 items.
ViewLeft
Returns the first N characters of a string.
ViewLen
Returns the number of characters in a text string, including spaces.
ViewLower
Converts a string to lowercase.
ViewREPT
Repeats a string N times. Result capped at 2000 characters.
ViewRight
Returns the last N characters of a string.
ViewRound
Rounds a number to a given number of decimal places.
ViewTrim
Removes leading, trailing, and extra internal spaces from text.
View