Concatenate multiple selections into one text

Visitor

I need to concatenate a multiple choice column in SharePoint Online List into a single text as calculated column.

Example:  If user selects "Shift A"  and "Shift B",   The calculated column will have "Worked on Shift A and Shift B" as single line text.

If user selects "Shift B"  and "Shift C",   The calculated column will have "Worked on Shift B and Shift C"  as single line text.

  

I have been searching on the web for the last 3 hrs. without success.  Anyone has a good trick to do that?  Much appreciated.      Thanks

1 Reply

@Ken_Ptx 

 

MultiSelected Choice field doesn`t support Calculated column and it doesn`t list the column to add it to formula of Calculated column

 

This applies to SharePoint Online and On-Prem.

 

We need to implement a remote event receiver 

https://www.tatvasoft.com.au/blog/how-to-implement-remote-event-receiver-in-sharepoint-online/