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
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
No comments:
Post a Comment