Forum Discussion
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 value of the other column starts with 42..... than use another url:
=IF(LEFT([IFS order_SAP Melding], 2)="41", "http://example.com/41" & [IFS order_SAP Melding], IF(LEFT([IFS order_SAP Melding], 2)="42", "http://example2.com/42" & [IFS order_SAP Melding], ""))
Unfortunately, I receive an syntax error message and cannot cope what the issue is.
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 ','.
4 Replies
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 ','.
- Thanks. That's what we call stupidity. Of course, I had to change the separator.
- DekkerNick1 Some time ago, I spent so much time resolving it that I will remember it forever. 😉
DekkerNick1 I can't reproduce this as I don't get an error when using your formula copied from the post. The IFS...column that it refers to is a number column with no decimal places:
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
