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...
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