Tuesday, January 5, 2010

SharePoint calculated columns and variations?

I had a very spooky issue today that took me a good deal of time to resolve.

On a list in an English variation I have a calculated column called CalculatedExpiry with a formula that looks like this:
=IF(Expires="",DATE(2099,1,1),Expires)
  and that works just fine, if the Expires field is empty, it set it to 1. January 2099

I then created the same calculated column on a Danish variation of the site, but when I wanted to save it I got the "The formula contains a syntax error or is not supported."
Even though they where identical...

After a lot of testing and googling I came accross this post, which suggested to replace the commas (,) in the formula with semicolons (;) and what do you know, it works!

So in the Danish variation the calculated columns formula now looks like this:
=IF(Expires="";DATE(2099;1;1);Expires)

2 comments:

  1. hi Simon
    I have been trying to use a Calculated column (%complete) as a value for my Gantt chart. The chart fails to depict the column value.
    Some say that it is a bug. Have u tried something similar?

    ReplyDelete
  2. Btw, did you get a solution to ur query on "Twitter for SharePoint"?
    ________________________________________________
    On 03 Nov 2009 12:42, Jesper Simonsen
    I successfully installed this and it works, sort of...
    I can create messages, but it says
    'Welcome null' and all messages says 'x minutes ago by null' even if I sign in with a different user. Any ideas why this is so?
    Thx, Jesper

    ReplyDelete