Forum Discussion
DekkerNick1
Jun 18, 2024Copper Contributor
Calculated Column gives syntax error based on another column
I have created a calculated column based on the value from another column. Typically, it should state the following: If the value of the other column starts with 41.... than use an URL, if the ...
- Jun 18, 2024
Hi DekkerNick1, if Rob_Elliott confirms that the formula is correct, then maybe it is a language issue?
https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v%3Doffice.14)#important-notes in some languages, ';' has to be used instead of ','.
michalkornet
Jun 18, 2024Iron Contributor
Hi DekkerNick1, if Rob_Elliott confirms that the formula is correct, then maybe it is a language issue?
https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v%3Doffice.14)#important-notes in some languages, ';' has to be used instead of ','.
- DekkerNick1Jun 24, 2024Copper ContributorThanks. That's what we call stupidity. Of course, I had to change the separator.
- michalkornetJun 24, 2024Iron ContributorDekkerNick1 Some time ago, I spent so much time resolving it that I will remember it forever. 😉