Forum Discussion
Solved
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 ...
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 ','.
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)