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.

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.
=TEXT([Event Date],“MMM”)        
>>> can be changed to >>>>
=TEXT([Event Date];“MMM”)

Happy programming!


Single Post Navigation

Leave a Reply

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

You are commenting using your 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: