Sharepoint Calculated Value Column to Reference multiple fields

Occasional Contributor



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?


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





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 ; 




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