Saed Al Shaar Dev Tips and Tricks

.NET and SharePoint from a different angle!

Calculated Columns in SharePoint Lists Dilimiter Issue


Hi Folks,

There are many blogs and articles talking about the Calculated Columns in SharePoint or Excel , but few of them highlight the issue with the dilimiters of the formulas.

http://office.microsoft.com/en-au/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx?CTT=3

While formulating the formula, you need to know what is the character used by your SharePoint to dilimiter the paramerters, usually it’s the comma (,), but sometimes it’s the simicoln (;).

So, if you are sure about the formula and it’s not working, then try to change the dilimiter and it will work.
Example:
=TEXT([Event Date],“MMM”)        
>>> can be changed to >>>>
=TEXT([Event Date];“MMM”)

Happy programming!
Saed

Advertisements

Single Post Navigation

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

%d bloggers like this: