concatenating dates
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?
Answers
-
Try this
=[BHI Cell1] + YEAR(Date1) + "." + MONTH(Date1) + "." + DAY(Date1)
-
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)?
-
@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)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives