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)
hi Simon
ReplyDeleteI 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?
Btw, did you get a solution to ur query on "Twitter for SharePoint"?
ReplyDelete________________________________________________
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