I have a calculated column with the formula:
This formula works fine on our DEV machine and another SharePoint site (on two different web applications) and also in Excel. Therefore the syntax must be correct.
When I put this formula in a calculated column on the Production SharePoint site (on yet another web application), I get the error: "This formula contains a syntax error or is not supported"
I've narrowed down the issue to the "REPLACE" function (IF, ISNUMBER and FIND seems to work fine; I don't get any error message on the Production SharePoint site when I create a calculated column with one of these functions).
Any suggestions? Is there some way to "active/enable" the "REPLACE" function? Or what can be different between the web applications, for it to work on two but not on the third?