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, especially before the first coffee of the morning. I know there is a way to get rid of the decimal places on a number but is it TRUN, or TRUNC, or TRUNK – oh no, hang on, that last one is just to do with elephants!
So, over the years we’ve gathered together a quick reference of some of the most commonly used functions and formulas – stuck on a wall above the desk it saves a lot of time and head scratching. We’ve found ourselves sending it to clients from time to time, and they seem to find it quite handy too.
So we decided to tidy it up – clean off the coffee stains and make a nice PDF of it – and make it available to download, free – yes that’s right, FREE!
So why not download our free Calculated Column Cheat Sheet and save yourself some time and headaches? 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.
Download, print, stick it on the wall, and we hope you find it as handy as we do!