Sharepoint Calculated Value Column to Reference multiple fields

%3CLINGO-SUB%20id%3D%22lingo-sub-3280576%22%20slang%3D%22en-US%22%3ESharepoint%20Calculated%20Value%20Column%20to%20Reference%20multiple%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3280576%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20continue%20with%20the%20below%20formula%20to%20reference%20more%20column%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DTEXT(%5BSelective%20Onsite%20Day%201%5D%2C%22dddd%20mmmm%20yy%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20working%20with%20one%20column%20%3D%26nbsp%3B%20Friday%20April%202022%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20how%20do%20i%20reference%203%20more%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20several%20attempts%20but%20cant%20get%20it%20working.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DTEXT(%5BSelective%20Onsite%20Day%201%5D%26amp%3B%20%22%20%22%20%26amp%3B(%5BSelective%20Onsite%20Day%202%5D%2C%22dddd%20mmmm%20yy%22))%20-%20Failed%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3280576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3280687%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Calculated%20Value%20Column%20to%20Reference%20multiple%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3280687%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApologies%20for%20not%20being%20clear%20but%20I%20managed%20to%20resolved%20my%20initial%20inquiry.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20new%20question%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20Calculated%20Value%20Column%20with%20the%20below%20formula%20%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%3DTEXT(%5BSelective%20Onsite%20Day%201%5D%2C%22dddd%20mmmm%20dd%22)%26amp%3B%22%20%22%26amp%3BTEXT(%5BSelective%20Onsite%20Day%202%5D%2C%22dddd%20mmmm%20dd%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20working%20result%20%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22batvan276_0-1649508484392.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F362567iBE268A45D2628B99%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22batvan276_0-1649508484392.png%22%20alt%3D%22batvan276_0-1649508484392.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20take%20it%20a%20step%20further%20to%20make%20line%20breaks%20between%20each%20date%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3280662%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Calculated%20Value%20Column%20to%20Reference%20multiple%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3280662%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891171%22%20target%3D%22_blank%22%3E%40batvan276%3C%2FA%3E%26nbsp%3Bwhat%20is%20the%26nbsp%3B%20-%20Failed%3F%20Is%20it%20just%26nbsp%3Btext%20or%20are%20you%20trying%20to%20do%20an%20if%2Fthen%2Felse%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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?