![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Dear Navya,
Good day!!
Apologies for the inconvenience caused and please don’t worry, let’s work together on your concern and move towards a resolution path.
As per the description shared, I understand your concern but since you have mentioned the same formula works in the different SharePoint Online site, I believe the regional settings of the working SharePoint Online site is different with the regional settings of the problematic SharePoint Online site.
So, I request you to check the regional settings of the both SharePoint Online site via: Open the Site> Settings> Site Information> View all site settings> Regional Settings.
If both are not same, then I would like to request you to replace the separator in the formula where you are encountering the syntax error. For example, if you are using , use ; and if you using ; please use ,
Note: Some regional settings supports the separator as comma and some regional settings supports semi-colon as a separator.
If the same problem persists, I would like to request you to share the screenshot of the regional settings of the problematic SharePoint Online site and formula using at your end.
Appreciate your patience and understanding. Have a great day!!
Best Regards,
Sophia