0

I need to create a calculated column with the value from the Title column and the date part from a Date & Time column, separated by a space and the date format like YYYY-MM-DD.

Something like this:

Title               StartDate            Calculated
Some title here     2019-03-13 08:00     Some title here 2019-03-13

Can someone please help me with the formula?

  • What have you tried so far? The community is happy to help you, but please share your efforts so far :) – Robert Lindgren Mar 13 at 12:54
0

This can be done, you can refer to below steps:

  1. Create a new calculated column called "calculated date only" to only display the Date value of the "StartDate" column.

enter image description here

  1. Create another calculated column called "calculated". Using below formula:

=Title&" "&TEXT([calculated date only],"YYYY-MM-DD")

enter image description here

  1. Then save you changes and your purpose will achieve. Please ignore the date format in the "StartDate" and "calculated date only" columns, I only did a simple test

enter image description here

  • Thanks for your reply. I tried your suggestion. The first calculated column worked like expected giving only the date. I call that column "StartdateOnly". However, when I try the second column, I get "The formula contains a syntax error or is not supported.". I've tried: =[Title]&" "&TEXT([StartdateOnly],"YYYY-MM-DD") =[Title]&' '&TEXT([StartdateOnly],'YYYY-MM-DD') =Title&' '&TEXT(StartdateOnly,'YYYY-MM-DD') =[Title]&" "&TEXT([StartdateOnly]) =[Title]&' '&TEXT([StartdateOnly]) =Title&' '&TEXT(StartdateOnly) Nothing works. – Papageno Mar 14 at 9:11
  • Directly use below in the formula: =Title&" "&TEXT([StartdateOnly],"YYYY-MM-DD") – imp. MSFT Mar 14 at 9:42
  • If also do not work, enter the formula manually, do not paste. Pay attention there is a space between " ". – imp. MSFT Mar 14 at 9:44
  • No, sorry. I follow your instructions in detail, but get the same error. I've even deleted the column and created a new one with a different name. Same discouraging reslut. – Papageno Mar 18 at 9:03
  • You may add some more screenshots for helping me solve your issue. This should work that I have test in my Online environment. Also you can test this in a new list. – imp. MSFT Mar 20 at 8:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.