0

I have Created a Date and Time column, Based on on that i have taken calculated column to concatenate Text and Date. But it is not showing Date format in calculated column. Can you please help with this.

Formula:

=CONCATENATE(" An Ally Bank Branch"," ",Title," ","is established on",[Established Date])

enter image description here

2
  • Try this: =CONCATENATE(" An Ally Bank Branch"," ",Title," ","is established on",TEXT([Established Date],"mm/dd/yyyy")) Jul 31, 2023 at 8:09
  • Hi @Chandrika, is below solution working for you? If yes, please Upvote(^) and accept it as an Answer (by clicking the "checkmark" button underneath the vote buttons) as it helped you & it will help others with similar question in future to find the correct answer easily, thanks! Aug 10, 2023 at 8:02

1 Answer 1

0

Try using formula like this:

=IF(ISBLANK([Established Date]),"",CONCATENATE("An Ally Bank Branch"," ",Title," ","is established on: ",TEXT([Established Date],"mm/dd/yyyy")))

This shows text description only when date column is not blank.

Output:

enter image description here

Note:

  1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  2. Use correct display name of your SharePoint columns in above formula.
  3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

Official Documentations:

  1. Calculated Field Formulas

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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