May 31 2022 06:30 PM
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?
Jun 01 2022 07:51 AM
@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)