SOLVED

Display both Date and Text in a single SharePoint column?

Brass 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?

 

VeeExcelLearn_0-1660488249496.png

 

2 Replies

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

 

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

best response confirmed by VeeExcelLearn (Brass Contributor)
Solution

@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.    

 

PamDeGraffenreid_0-1660513136013.png

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.

PamDeGraffenreid_1-1660513443096.png

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

 

1 best response

Accepted Solutions
best response confirmed by VeeExcelLearn (Brass Contributor)
Solution

@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.    

 

PamDeGraffenreid_0-1660513136013.png

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.

PamDeGraffenreid_1-1660513443096.png

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

 

View solution in original post