SharePoint Calculated Column and Nested IF’s Limitation Cheat Sheet

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

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

One thought on “SharePoint Calculated Column and Nested IF’s Limitation Cheat Sheet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s