Calculating Age in SharePoint calculated field

Calculating Age in SharePoint calculated field

How to trick SharePoint into accepting today’s date in a calculated column.

How to reference a ‘Multiple Lines of Text’ column in a ‘Calculated Column’ to display a complete list of appended changes to all items on a list as a group

How to reference a ‘Multiple Lines of Text’ column in a ‘Calculated Column’ to display a complete list of appended changes to all items on a list as a group

Useful little trick, basically just switching the columns the calculated column refers to.

Calculated Columns, Formulas & Functions in Sharepoint

There is no defending myself against the accusation that this blog is getting too much SharePoint-centric. My only excuse is that calculated columns are way, way underused in SharePoint and are a mighty tool for various purposes. These sites compile almost all (i am joking, of course, i can only scratch the surface in this regard) there is to know about calculated columns:

  • SharePoint Formulas and Functions at MS [Link]
  • Examples of Common Formulas at MS [Link]
  • Also make sure to take a look at the ‚Taming the Elusive Calculated Column‘-series at EndUserSharePoint, great stuff [Link]