I thought I would gather some information on the limitations of calculated columns and nested if statements in different SharePoint versions. This is just meant to act as a really basic limitations cheat sheet which I’ll update if I find out anything new.

Nested IF Limitations by SP Version

SharePoint 2007 & 2010

• Limit of 7 nested if statements
  • workaround – https://blog.pathtosharepoint.com/2010/04/12/maximum-number-of-if-statements-in-a-calculated-column/

SharePoint 2013

• Limit of 39 nested if statements
  • Workaround – Presumably the workaround I linked to above should work, however I’d suggest against going close to this limit normally.

 

Calculated Column Limitations

SharePoint 2007 & 2010

• 1024 Character Limit
• 48 Calculated Columns per list max.
• Cannot access value of following fields –
  • [Today]
  • Any lookup fields

SharePoint 2013

• 1,073,741,823 character limit
• 48 Calculated Columns per list max.
• Cannot access value of following fields –
  • [Today]
  • Any lookup fields