Forum Discussion
fgtom
Jun 01, 2022Copper Contributor
Is it possible to display date in a column that is not date column?
I'm thinking to combine multiple information into one column, but I'm having trouble with displaying date value, which will be shows as serial number.
For example, I would like to do like this within a single cell:
==
First test: 2022/5/31 "Test was already performed"
Second test: 2022/6/2 "Test will be performed soon"
==
Is there a way for this?
1 Reply
Sort By
- RobElliottSilver Contributor
fgtom whilst I can't think why you would want to combine columns as it will make filtering, views etc much more difficult, it is possible even with a DateTime column by creating a calculated column using a formula like this:
=CONCATENATE(Title&" "&TEXT([Review Date],"dd/MM/yyyy")&" "&Region&" "&Result)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)