Apr 08 2022 07:05 PM
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?
Apr 09 2022 04:11 AM
@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)
Apr 09 2022 05:49 AM
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 ;
How can I take it a step further to make line breaks between each date?