concatenating dates

Olivia Henry · 09/30/20

I'm trying to concatenate a client code column (in a text format) with a long form date column (2018.04.27) so the concatenated column would appear like this — BHI2018.04.27. But, when the date appears in the concatenated column it shows up as BHI09/08/20. Is there a way to make the slashes go away, or have it appear in the same format as the long form date column?

John Jonassen · 09/30/20

Try this

=[BHI Cell1] + YEAR(Date1) + "." + MONTH(Date1) + "." + DAY(Date1)

Olivia Henry · 09/30/20

https://community.smartsheet.com/discussion/comment/264298#Comment_264298

Hi John,

Right now the concatenate column formula is this: =[Client Code]69 + Created69

BHI is the example client code from row 69

Created is the example date from row 69 that is formatted as 2018.04.27

So, where would I paste the formula YEAR(Date1) + "." + MONTH(Date1) + "." + DAY(Date1)?

John Jonassen · 09/30/20

@Olivia Henry So knowing your true column header names, here is what the formula would like like in your sheet.

=[Client Code]69 + Year(Created69)+"."+Month(Created69)+"."+Day(Created69)

concatenating dates

Answers

Categories