SOLVED

SharePoint List column calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-1494852%22%20slang%3D%22en-US%22%3ESharePoint%20List%20column%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494852%22%20slang%3D%22en-US%22%3E%3CP%3Ein%20a%20share%20point%20list%2C%20how%20to%20calculate%20a%20content%20of%20column%3F%20See%20image.%26nbsp%3B%20I%20want%20%22SOS%22%20appended%20with%20month%20and%20date%20(MMDD)%20from%20the%20received%20date%20column.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20a%20revived%20date%2006%2F28%20It%20should%20finally%20look%20%3A%20SOS-0628%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%22cad-one_0-1593375345486.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201775iDF12642A216168EE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22cad-one_0-1593375345486.png%22%20alt%3D%22cad-one_0-1593375345486.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1494852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecolumn%20calculation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495225%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20column%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495225%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712688%22%20target%3D%22_blank%22%3E%40cad-one%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20%22SOS%20Number%22%20as%20calculated%20column.%3C%2FP%3E%3CP%3EHere%20is%20a%20formula%20for%20the%20column%3A%26nbsp%3B%3CBR%20%2F%3E%3DCONCATENATE(%5BSOS%5D%2C%22-%22%2CTEXT(%5BReceived%20date%5D%2C%22MM%2Fdd%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

in a share point list, how to calculate a content of column? See image.  I want "SOS" appended with month and date (MMDD) from the received date column. Is this possible?

 

For a revived date 06/28 It should finally look : SOS-0628

 

cad-one_0-1593375345486.png

 

1 Reply
Highlighted
Best Response confirmed by cad-one (Occasional Contributor)
Solution

Hi @cad-one,

 

Create "SOS Number" as calculated column.

Here is a formula for the column: 
=CONCATENATE([SOS],"-",TEXT([Received date],"MM/dd"))