SharePoint Calculated Column value -329378600

When migrating to SharePoint 2013, there are some differences that may impact when checking calculated columns.

We had a list/library that was from SharePoint 2007.

In the following (complicated) example, the ‘end value’ was wrong :

=IF([Action 2 When]=””,””,IF(AND([Action 2 When]>=[Last Report Date],[Action 2 When]<=[Todays Date]),”Newly Late”,IF([Action 2 When]<[Last Report Date],”Still Late”,”On Time”)))

The value was being shown as :

;#-329378600

WTF ?

It turned out that this was an EXCEPTION code – and the formula was getting null’ed out somewhere along the line.

The answer was to make sure to put “space” in an empty value :

=IF([Action 2 When]=””,” “,IF(AND([Action 2 When]>=[Last Report Date],[Action 2 When]<=[Todays Date]),”Newly Late”,IF([Action 2 When]<[Last Report Date],”Still Late”,”On Time”)))

Very subtle different – but it seems to resolve the problem (!)

HTH.   🙂

Advertisements

One thought on “SharePoint Calculated Column value -329378600

  1. After looking into a few of the blog posts on your web site, I really
    appreciate your way of writing a blog. I added
    it to my bookmark website list and will be checking back soon.
    Please check out my web site too and tell me how you feel.

    Like

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