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.

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.

Go to top

SharePoint List Function Reference

SharePoint: AND Function

Full Reference

SharePoint: AVERAGE function

Full Reference

SharePoint: CONCATENATE Function

Full Reference

SharePoint: Choose Function

Full Reference

SharePoint: DateDif Function

Full Reference

SharePoint: Day Function

Full Reference

SharePoint: Hour Function

Full Reference

SharePoint: IF Function

Full Reference

SharePoint: ISBLANK Function

Full Reference

SharePoint: ISERROR Function

Full Reference

SharePoint: ISLOGICAL Function

Full Reference

SharePoint: ISNA Function

Full Reference

SharePoint: ISNONTEXT function

Full Reference

SharePoint: ISNUMBER Function

Full Reference

SharePoint: ISTEXT Function

Full Reference

SharePoint: Int Function

Full Reference

SharePoint: Left Function

Full Reference

SharePoint: Len Function

Full Reference

SharePoint: Lower Function

Full Reference

SharePoint: Now Function

Full Reference

SharePoint: OR Function

Full Reference

SharePoint: REPT Function

Full Reference

SharePoint: Right Function

Full Reference

SharePoint: Round Function

Full Reference

SharePoint: RoundDown Function

Full Reference

SharePoint: RoundUp Function

Full Reference

SharePoint: Today Function

Full Reference

SharePoint: Trim Function

Full Reference

SharePoint: WEEKDAY Function

Full Reference
Go to top