3 Commonly Utilized SharePoint Formulas

The following are three commonly used SharePoint formulas:

1. IF formula: This formula is utilized to check whether a condition is met or not. It returns one value if the condition is true and another value if the condition is false. Example: =IF([Column1]>[Column2], "Yes", "No")
2. SUM formula: This formula is utilized to add up the values in a column. Example: =SUM([Column1], [Column2], [Column3])
3. DATEDIF formula: This formula is utilized to calculate the difference between two dates in days, months, or years. Example: =DATEDIF([Column1], [Column2], "d").