Jun 28 2020 01:20 PM
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
Jun 28 2020 09:45 PM
SolutionHi @cad-one,
Create "SOS Number" as calculated column.
Here is a formula for the column:
=CONCATENATE([SOS],"-",TEXT([Received date],"MM/dd"))
Jun 28 2020 09:45 PM
SolutionHi @cad-one,
Create "SOS Number" as calculated column.
Here is a formula for the column:
=CONCATENATE([SOS],"-",TEXT([Received date],"MM/dd"))