Answer the question
In order to leave comments, you need to log in
How to combine text and date in a SharePoint cell, in a calculated column?
There is a calculated column that contains the following formula =[Name]&TEXT([Due Date],"dd-mm-yyyy hh:mm"), after confirming the changes, SP issues: "The formula contains a syntax error or is not supported."
I suspect that the problem is with the format (Format of the [Due Date] field is date and time), I tried many format options, starting from "dd-mm-yyyy" and ending with "mm/dd/yyyy" (although I may be some missed).
Version - SharePoint Server 2019
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question