Forum Discussion

cad-one's avatar
cad-one
Brass Contributor
Jun 28, 2020
Solved

SharePoint List column calculation

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

 

 

column calculation
  • Matti Paukkonen's avatar
    Matti Paukkonen
    Jun 29, 2020

    Hi cad-one,

     

    Create "SOS Number" as calculated column.

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

  • Matti Paukkonen's avatar
    Matti Paukkonen
    Iron Contributor
    Jun 29, 2020

    Hi cad-one,

     

    Create "SOS Number" as calculated column.

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

Resources