SharePoint Calculated Column Cheat Sheet

Calculated columns are a really useful feature of any SharePoint list.

Whether you want to automatically show the profit on a sale, or the financial year that a date falls in to, or tidy up sloppy user input by capitalising names. There is a lot you can do it with a Calculated Column.

But remembering the formulas and functions needed is not always easy.

SharePoint Calculated Column Cheat Sheet

This easy 3 page reference sheet gives you a selection of commonly used calculated column formulas, along with a pretty thorough reference of most of the functions and operators you are likely to need in your day to day work.


Calculated Column Cheat Sheet


For more inspiration and real life examples on what you can do with calculated columns, check out our blog.