SharePoint List Function Reference

Here you'll find my working reference for SharePoint list formula functions, the calculated-column and validation functions that let you shape data inside a list without writing code. Microsoft's documentation tells you what each one does. My aim is to add the practical context you only gather after building real lists. Every entry focuses on a single function. I cover the math basics like the "Abs", "Average", and "Even" functions, and where they shine in calculated columns. For dates, I walk through the "Date", "DateValue", "DateDif", and "Day" functions, since date handling in SharePoint has its own quirks. On the text side, I explain the "Concatenate", "Char", and "Code" functions and how they fit together when formatting output. I also cover logic and lookups with the "And" and "Choose" functions. For each one I lay out the syntax, give you a worked example, and flag the limitations.