SOLVED

SharePoint List column calculation

Brass 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
best response confirmed by cad-one (Brass 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"))

1 best response

Accepted Solutions
best response confirmed by cad-one (Brass 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"))

View solution in original post