Sharepoint Calculated Value Column to Reference multiple fields

Copper Contributor

Hello. 

 

I want to continue with the below formula to reference more column; 

 

=TEXT([Selective Onsite Day 1],"dddd mmmm yy")

 

Its working with one column =  Friday April 2022

 

but how do i reference 3 more column?

 

I had several attempts but cant get it working. 

 

=TEXT([Selective Onsite Day 1]& " " &([Selective Onsite Day 2],"dddd mmmm yy")) - Failed 

 

Can someone help?

2 Replies

@batvan276 what is the  - Failed? Is it just text or are you trying to do an if/then/else formula?

 

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

@RobElliott 

 

Hello,

 

Apologies for not being clear but I managed to resolved my initial inquiry. 

 

I have a new question; 

 

I created a Calculated Value Column with the below formula ;

 

==TEXT([Selective Onsite Day 1],"dddd mmmm dd")&" "&TEXT([Selective Onsite Day 2],"dddd mmmm dd")

 

This is the working result ; 

 

batvan276_0-1649508484392.png

 

How can I take it a step further to make line breaks between each date?