Display both Date and Text in a single SharePoint column?

Frequent Contributor

Is there a way to display date and text in a single column? So that it is a date picker but also the option to type in text or does this mess things up?




2 Replies

@VeeExcelLearn a column can only have 1 data type so this isn't possible.


Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

best response confirmed by VeeExcelLearn (Frequent Contributor)

@VeeExcelLearn Rob is correct, you can't have a single column that does has text and a date.  However, a text and date field can be displayed together using a calculated column.    



Here is what I used to format the calculated column.

=Text&" - "&TEXT(Date,"dd mmm yy")

Depending on the requirements, you might want to put that in an IF statement to adjust the formatting if there is missing information.


=Text&IF(Date>0," - "&TEXT(Date,"dd mmm yy"),"")